Series with different dates on same chart
Posted: Wed May 02, 2007 7:40 am
Hi,
I would like some advice on how I could plot 2 series with possibly different dates (users will specify what date range they want to look for both series) on the same chart and also have the difference between each data point being plotted out as well.
For example, the dataset to plot the 2 series could be similar to below:
Date1, Data1, Date2, Data2, Difference (Data1-Data2)
1-Jan-2007, 10, 15-Jul-2006, 5, 5
2-Jan-2007, 15, 16-Jul-2006, 10, 5
3-Jan-2007, 10, 17-Jul-2006, 10, 0
4-Jan-2007,10,null,null,10
I would like to have Date1 & Data1 as one series, Date2 & Data2 as second series and Difference as another series (?) on the same chart.
Would you have any suggestions on how the x-axis should be (since there are 2 different dates)? Or how could the users still see the dates for the 2 series?
Thank you.
I would like some advice on how I could plot 2 series with possibly different dates (users will specify what date range they want to look for both series) on the same chart and also have the difference between each data point being plotted out as well.
For example, the dataset to plot the 2 series could be similar to below:
Date1, Data1, Date2, Data2, Difference (Data1-Data2)
1-Jan-2007, 10, 15-Jul-2006, 5, 5
2-Jan-2007, 15, 16-Jul-2006, 10, 5
3-Jan-2007, 10, 17-Jul-2006, 10, 0
4-Jan-2007,10,null,null,10
I would like to have Date1 & Data1 as one series, Date2 & Data2 as second series and Difference as another series (?) on the same chart.
Would you have any suggestions on how the x-axis should be (since there are 2 different dates)? Or how could the users still see the dates for the 2 series?
Thank you.