Wednesday, December 30, 2009 – Permalink –
Chart Null Data Gaps
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.
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
<Doug Klippert@ 3:18 AM
Comments: Post a Comment