Line chart w/ multiple series, diff label values-problem
Posted: Mon Nov 06, 2006 9:55 pm
I am trying to create a line chart with multiple series where all the series may not share the same x-axis values. All series use dates for the labels one of the series may use a different set of date values.
For example, the data for the first two series may look like:
Label - S1 Value - S2 Value
1/1/2006 - 4 - 5
4/1/2006 - 3 - 4
6/1/2006 - 7 - 9
But the data on the final series may look like this:
Label - S3 Value
2/1/2006 - 4
5/1/2006 - 7
8/1/2006 - 6
Currently when I set up these series, the third series values are plotted on the same labels as the other series. In the above example, the 2/1/2006 point will be plotted with the 1/1/2006 x-axis label, the 5/1 will show up on 4/1, etc.
Is there any way to mix two sets of data with different x-axis values?
For example, the data for the first two series may look like:
Label - S1 Value - S2 Value
1/1/2006 - 4 - 5
4/1/2006 - 3 - 4
6/1/2006 - 7 - 9
But the data on the final series may look like this:
Label - S3 Value
2/1/2006 - 4
5/1/2006 - 7
8/1/2006 - 6
Currently when I set up these series, the third series values are plotted on the same labels as the other series. In the above example, the 2/1/2006 point will be plotted with the 1/1/2006 x-axis label, the 5/1 will show up on 4/1, etc.
Is there any way to mix two sets of data with different x-axis values?