2
I have the following data:
Date Name Value
1/1/2011 FOO 10
1/1/2011 BAR 12
2/1/2011 FOO 16
3/1/2011 BAR 21
5/1/2011 FOO 19
4/1/2011 BAR 23
Note that 'Dates' are not ordered. Note also that I have two different values in 'Name'.
I would like a chart like a XY (scatter) chart that shows 2 lines, one for FOO, one for BAR.
The chart must have a X-axis representing dates (correctly spaced relatively to each other value)
The chart must have a Y-axis representing values (correctly spaced relatively to each other value)
Maybe a line chart would do the trick? Please, if possible, avoid any new computation of values, or restructuring the table data. It seems easy for a tool like Excel to create such a chart without helping it by predoing some work on the data...
I've written a tutorial showing how to split the data into series based on a category column in VBA to Split Data Range into Multiple Chart Series. You need to sort by the category column first.
– Jon Peltier – 2015-07-29T23:23:26.410