If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
omit zero 'spikes' in charts
Im trying to do a chart showing a quantity versus day of
week. How can I easily filter out weekend readings, which are often zero, and make the chart not very readable? Any help much appreciated |
#2
|
|||
|
|||
omit zero 'spikes' in charts
Paul -
If the cells are true blanks (no formulas), you can alter their treatment in the chart. On the Tools menu, select Options, then click on the Chart tab. Pick another option for Plot Empty Cells As. If the cells only appear empty by virtue of a formula that returns "", you need to return NA() instead, the #N/A error. It looks ugly, but the chart draws a line connecting the points on either side, making the chart look better. Use conditional formatting to hide the error values; Debra Dalgleish shows how on this web page: http://contextures.com/xlCondFormat03.html#Errors Use ISNA() instead of ISERROR() if you want to show other errors. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Paul Foster wrote: Im trying to do a chart showing a quantity versus day of week. How can I easily filter out weekend readings, which are often zero, and make the chart not very readable? Any help much appreciated |
Thread Tools | |
Display Modes | |
|
|