Using EXCEL Graph to show two series in different timeframes??!!

Dear all,

This is my first message posted with Tek-Tips, any help will be deeply appreciated.

I'm trying to get an Excel graph to show 2 series; one referencing 24 months of data [series A](e.g. 2001 and 2002 figures) and the other referencing only 12 months of data [series B](e.g. only 2002 figures).

Series A and B must be shown on the same graph and series B must appear in the right half on the graph because the x-axis goes from 2001 to 2002.

This may sound easy at first, but there are limitations to what can be done:

1. The data ranges for A and B must contain all 24 months data. (i.e. can't change the first 12 months of B to #n/a)

2. if all possible, I'm very reluctant to manually 'hide' the first 12 points on series B in the graph one by one because there is quite a number of such graphs that I need to do.

When I select the last 12 month of the data range for series B, Excel moves it to the left half of the graph (2001) even though it was meant to be 2002 data.

Thanks for your attention and patience with this long message. Please, HELP~~~~~~~~ ahahaa... >_<

Cheers,
ccat