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/2/2005 1/10/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.