omit zero 'spikes' in charts

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top