|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Thursday, September 01, 2016 – Permalink – Chart Null Data GapsFill in the spacesWhen 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 excel Labels: Charts, Formats, General, Reference, Tips, Tutorials <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
|
