I am having some major problems with charting and I am hoping someone can help me with this. I have to show trends of planned versus actual for over 50 different charts.
The following is an example of the data structure.
ID No. Planned Date Actual Date
----------------------------------------
1 1/4/2005 1/15/2005
3 2/14/2005
4 4/4/2005
I need to show the trend of planned vs. actual. In other words, I need to chart the planned and actual for each ID on a chart.
Currently, I have the "On Change of Planned Date, Show Values of ID No." This accurately charts the trend of planned dates only. But if I include the Actual Date, the chart is not correct anymore. I can't figure out how to chart both planned and actual on one chart. Any ideas will be greatly appreciated.
Thanks in advance.
The following is an example of the data structure.
ID No. Planned Date Actual Date
----------------------------------------
1 1/4/2005 1/15/2005
3 2/14/2005
4 4/4/2005
I need to show the trend of planned vs. actual. In other words, I need to chart the planned and actual for each ID on a chart.
Currently, I have the "On Change of Planned Date, Show Values of ID No." This accurately charts the trend of planned dates only. But if I include the Actual Date, the chart is not correct anymore. I can't figure out how to chart both planned and actual on one chart. Any ideas will be greatly appreciated.
Thanks in advance.