Help with creating a line chart

**DaveMTR** · 01-04-2019, 12:57 PM

Hi All,

I have data that I need to try and chart, to look at a trend of faults in work

I enter the data in the first tab (Screenshot below)
1.png

This then populates a second tab, where I have counted the total per day, then broken it up into hourly segments (which I plan on hiding) (Screenshot below).
2.png

I am trying to create a chart, a line chart (I think) to show the time on the vertical axis and the day on the horizontal axis (Again...I think).

Essentially, I am trying to look at a trend of what time of the day most faults come in, to see if there is a pattern over the 7 days (Note, the data I have used is just mock data whilst trying to figure this one out).

Any help is appreciated.

Kind regards
Dave.

**MrShorty** · 01-04-2019, 01:08 PM

Are you generally familiar with creating charts in Excel? Specific parts of creating a line chart that you are uncertain of? Based on your screenshots, here's how I might go about creating a line chart:

1) The totals row (row 3) is going to complicate the process. It is not strictly necessary, but I would be tempted to move the totals row either to the bottom of the table or to the top of the table (above the day of week row).
2) Select the table (C2:J31) and insert a line chart.
3) Excel will probably default to "data in columns" for the chart -- where "time of day" is going across the horizontal axis and each day of the week is a separate series. It sounds like you want day of week on the horizontal axis and time of day as separate series -- in other words, you want "data in rows". If Excel defaults to data in columns, click on the "switch row/column" command button.
4) If you did not move the totals row in step 1, then you will probably want to delete the totals series at this point.

That should be close to a "count of incident versus day of the week at different times of day" line chart. Is that what you are trying to do? What does it do well? What does it lack?