omit zero 'spikes' in charts

  • Thread starter Thread starter Paul Foster
  • Start date Start date
P

Paul Foster

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
 
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
 
Back
Top