I would rearrange your data and then use a pivot chart. Also, now you can select different categories within one chart.

Attached Files

Fuel Lid LMI Sheet - Copy (7).xlsx (21.8 KB, 10 views)

jcyo233, the plots are bunching up on the left because you're plotting some 3000 points, so there are 3000 categories on your x-axis. Reduce that to plot just the 30 odd points you've got data for and it stops the bunching, but doesn't stop the multiple categories for the same date on the x-axis.



This is a difficult one; I've been playing with it and can't get a straightforward solution.
The problem I'm facing is getting multiple points to show on one date.


jeffreybrown, you've used Sum of Gap in the pivot table, and when there are multiple points on one date they're added! I tried changing that to Average of Gap which better represents the data, but still we lose the individual points for that data.


I attach your data set, re-arranged to play with.

Attached Files

msofficeforums40647.xlsx (24.8 KB, 8 views)