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...