Charting question - How Excel handles dates

use=na() in the gaps,so put another column next to first then something along the lines of if(isnumber(a2),a2,na()) use that for your source the #na get ignored

Select each of the non adjacent ranges while holding down the Ctrl Key, hit F11 and start from there

not having 2010 i cant say but i just created a greph of
date return
11/06/2012 5
12/06/2012 6
13/06/2012 7
14/06/2012 8
15/06/2012 9
18/06/2012 10
19/06/2012 11
20/06/2012 12
21/06/2012 13
22/06/2012 14
although it inserts the dates in ,it ignores them and you get a continuously ascending curve
there must be a setting

brick wall and head! its a known "bug" it existed in 2007 from micro soft

Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003
To resolve this behavior, format the axis to be a category axis instead of a time-scale axis. To do this, use one of the following methods.
Method 1
If you entered data on the worksheet but did not yet create the chart, follow these steps:
Select the data on the worksheet that is to be the source data for the chart.
Click Chart Wizard on the Standard toolbar.
Make the changes you want in steps 1 and 2 of the Chart Wizard.
In step 3 of the Chart Wizard, click the Axes tab.
Click Category under Category (X) axis.
Continue stepping through the Chart Wizard until the chart is created.
Method 2
If you already created the chart, follow these steps:
Click the chart to select it.
On the Chart menu, click Chart Options.
Click the Axes tab.
Click Category under Category (X) axes and click OK.
Back to the top
Microsoft Office Excel 2007
To resolve this behavior, format the axis to be a text axis instead of a date axis. To do this, follow these steps:
Right-click the axis that you want to change, and then click Format Axis.
In the Format Axis dialog box, click Axis Options.
Under Axis type, click Text axis, and then click Close.

Originally Posted by johnekeefe

By the way, I loved your 1937 film.

You're the first one to react on that ! Congrats !