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.
Quote:
Originally Posted by jeffreybrown
I would rearrange your data and then use a pivot chart. Also, now you can select different categories within one chart.
|
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.