Need help showing trend

[Aashish1981]

Hi Friends,

I have data for multiple projects in the format below for multiple dates (sample for two dates given below). I want to show the trend for a particular metrics date wise and project wise, so for eg Project 1 , Data representation metrics for 1-Jun-23 and 10-Jun-23 (could be more dates) , Need help on how we can do it.

Project	Date	Data Representation	Slide Aesthetics	Risk and Issues Articulation	Timeliness	Consistency
Project 1	1-Jun-23	2	4	3	5	1
Project 2	1-Jun-23	3	4	5	2	1
Project 3	1-Jun-23	1	2	3	4	5
Project 1	10-Jun-23	1	2	3	4	5
Project 2	10-Jun-23	2	4	3	5	1
Project 3	10-Jun-23	3	4	5	2	1

[#2]

@Aashish1981 

Here is an example with the given data:

Assuming your data is arranged in columns A to F, with headers in row 1, and the chart will be placed in a separate sheet named "Chart":

Project	Date	Data Representation	Slide Aesthetics	Risk and Issues Articulation	Timeliness	Consistency
Project 1	1-Jun-23	2	4	3	5	1
Project 2	1-Jun-23	3	4	5	2	1
Project 3	1-Jun-23	1	2	3	4	5
Project 1	10-Jun-23	1	2	3	4	5
Project 2	10-Jun-23	2	4	3	5	1
Project 3	10-Jun-23	3	4	5	2	1

To create a chart showing the trend for the "Data Representation" metric date-wise and project-wise, follow these steps:

1. Select the range A1:F6 (including the headers).
2. Press Ctrl+C to copy the data.
3. Go to the "Chart" sheet and select cell A1.
4. Press Ctrl+V to paste the data.
5. Click on the "Insert" tab and choose a chart type that suits your needs, such as a line chart or column chart.
6. Right-click on the chart and choose "Select Data" from the context menu.
7. In the "Select Data Source" dialog box, click on the "Add" button under the "Legend Entries (Series)" section.
8. In the "Edit Series" dialog box, specify the following:
• Series name: Enter "Data Representation".
• Series values: Select the range of values for the metric (A2:A6 in this example).
• Series X values: Select the range of dates (B2:B6 in this example).
9. Click "OK" to close the dialog box.
10. Customize the chart as desired by adding titles, labels, and adjusting the axis scales.
11. The resulting chart will show the trend for the "Data Representation" metric date-wise and project-wise.

You can repeat the process for other metrics by adding additional series to the chart using their respective ranges.

Remember to adjust the range references and sheet names according to your actual data and sheet names in Excel.

The exact appearance and layout of the Excel user interface may vary slightly between versions. Nonetheless, the core functionality and concepts remain the same.