Forum Discussion
Need help showing trend
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 |
- NikolinoDEGold Contributor
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:
- Select the range A1:F6 (including the headers).
- Press Ctrl+C to copy the data.
- Go to the "Chart" sheet and select cell A1.
- Press Ctrl+V to paste the data.
- Click on the "Insert" tab and choose a chart type that suits your needs, such as a line chart or column chart.
- Right-click on the chart and choose "Select Data" from the context menu.
- In the "Select Data Source" dialog box, click on the "Add" button under the "Legend Entries (Series)" section.
- 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).
- Click "OK" to close the dialog box.
- Customize the chart as desired by adding titles, labels, and adjusting the axis scales.
- 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.