Start scatter line data later in the graph

[TheSpauser]

As title suggests... I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this other data which starts around half way into the time period. So all the data starts in June 2010... but this other data starts in June 2012. I hope this is clear... any help offered would be greatly appreciated! Any questions please get back to me. Cheers in advance :D

 

[bruderbell]

Organize your data as such:
Col A - dates
Col B - First type certificates
Col C - Second type certificates

Every row should have a date, but needn't have an entry in both Col B and/or C. My test data is below:

Type A Type B
1-Jan 13
1-Feb 13
1-Mar 13
1-Apr
1-May
1-Jun
1-Jul 30
1-Aug 30
1-Sep 30
1-Oct 30
1-Nov 30
1-Dec 30

If you highlight this data, then insert chart, scatter, Excel 2010 picks up the two series automatically and does what I believe you are seeking.

 

[TheSpauser]

Fantastic... many thanks for your help mate.

 

[bruderbell]

You are welcome