Fill in the spaces
When creating a chart, data can sometimes be missing. You have a choice of leaving the cells empty or making them zero.
By default, an empty cell will leave gaps in your graph. Zero entries will send a line graph down to the base line.
One way to force Excel to interpolate the data is to enter the function =NA() in the empty cells.
Another way is to go to Tools>Options and choose the Chart tab.
Pick how you want data plotted - with gaps, as zero, or interpolated.
Microsoft also has this suggestion:
Gaps between the dates
"If the datasheet data for the category axis contains date number formatting, Microsoft Graph automatically uses a special type of axis in your chart called a time-scale axis.
A time-scale axis shows a blank category for dates for which you have no data. If you do not want to see these gaps — for example, if you have data for 1-Jan, 15-Jan, 3-Feb, 12-Feb, and 2-Mar, and you want to plot the days next to each other - you can change the time-scale axis to a standard category axis.
On the Chart menu, click Chart Options, click the Axes tab, and then click Category under Category (X) axis."
Note, For 2007+, on the Design tab, click Select Data in the Data area, and then click Hidden and Empty Cells on the Select Data dialog box.
See all Topics