Share via

Excel multiple line graphs with multiple categories on the same diagram

Anonymous
2022-02-18T08:35:33+00:00

I am struggling to make a line graph that is able to depict all five categories against the the same two common variables. All I am able to get at is one single graph where all data is accumulated. The table looks like the below and I want a line graph representing each location/category on the same diagram.

Location Date IN Hours per cycle
CWF 1 10 Dec 2021 62.50
CWF 1 13-Dec-21 53.17
CWF 1 15-Dec-21 42.17
CWF 1 18-Dec-21 23.67
CWF 1 19-Dec-21 23.75
CWF 2 11-Dec-21 62.83
CWF 2 14-Dec-21 80.00
CWF 2 17-Dec-21 21.75
CWF 2 19-Dec-21 33.25
CWF 2 21-Dec-21 30.83
VSA 2 9 Dec 2021 99.32
VSA 2 14 Dec 2021 108.75
VSA 2 19 Dec 2021 61.33
VSA 2 21 Dec 2021 56.17
VSA 2 24 Dec 2021 46.83
VSA 3 10 Dec 2021 86.00
VSA 3 13 Dec 2021 34.67
VSA 3 15 Dec 2021 35.08
VSA 3 16 Dec 2021 45.75
VSA 3 18 Dec 2021 47.00
VSA 4 14 Dec 2021 119.50
VSA 4 19 Dec 2021 109.33
VSA 4 24 Dec 2021 45.75
VSA 4 26 Dec 2021 62.83
VSA 4 29 Dec 2021 48.17
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2022-02-21T09:25:16+00:00

    You can add a new series with constant value 30. I have updated the workbook at https://www.dropbox.com/s/b74ys1rok8dl3xr/XYScatter.xlsx?dl=1

    0 comments
  2. Anonymous
    2022-02-21T05:00:47+00:00

    Hi Hans - Thanks a lot, much appreciated! Would you know how to add a horizontal line to depict a benchmark hours per cycle. For example on this scatter chart, I need to add a horizontal line at 30 hours per cycle which should should tell me which points lie below or above the threshold. What would be the best way to add this?

    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2022-02-18T12:17:07+00:00

    Since the X-values aren't the same for the five locations, you need an XY Scatter chart,

    Start by creating such a chart with just one series, for the first location CWF1.

    Then use the Select Data dialog to add the other locations.

    See https://www.dropbox.com/s/b74ys1rok8dl3xr/XYScatter.xlsx?dl=1

    0 comments