Thanks for that Jim,

I'll give it a go when I get back into the office.

I'll juts have to find a way to trigger it via code.

If not I'll use the 'union' function and insert dummy variables.



"Jim Cone" wrote in message
...
David,

If Tools | Options | Chart - "Not plotted ( leave gaps)" is checked
then
1. you can change your data for the non-plotted periods to zero or
2. switch to an alternate data source that has zeros for the non-plotted
periods.

Regards,
Jim Cone
San Francisco, CA