
|
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! |
![]() Sunday, November 04, 2007 – Permalink – Chart ArtApple π
Labels: Charts <Doug Klippert@ 5:39 AM
Comments:
Post a Comment
Wednesday, March 28, 2007 – Permalink – Data Scrutiny ChartsWays to look closer![]() Professional statisticians typically have powerful software at their disposal to perform advanced analyses and create slick graphs. But many professionals in the quality field don't enjoy that luxury.
Excel for Data Analysis See all Topics excel Labels: Charts <Doug Klippert@ 6:49 AM
Comments:
Post a Comment
Saturday, December 30, 2006 – 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. See all Topics Labels: Charts <Doug Klippert@ 5:41 AM
Comments:
Post a Comment
|