Need help showing trend

Platinum Contributor

Jun 13, 2023

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:

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.

Forum Discussion

Resources