Forum Discussion

Aashish1981's avatar
Aashish1981
Copper Contributor
Jun 13, 2023

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.

ProjectDateData RepresentationSlide AestheticsRisk and Issues ArticulationTimelinessConsistency
Project 11-Jun-2324351
Project 21-Jun-2334521
Project 31-Jun-2312345
Project 110-Jun-2312345
Project 210-Jun-2324351
Project 310-Jun-2334521
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

Resources