| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I avoid that zero values in the data set are displayed in.
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I avoid that zero values in the data set are displayed in.
[Please ask your question in the body of the message, not just in the
subject line.] Tools/ Options chart gives you various options for empty cells, but if your cells aren't actually empty but contain zeroes (or "" which counts as zero) then you may want to replace the zeroes by =NA() -- David Biddulph "stef" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid referencing hidden values in formulas like OFFSET? | Excel Worksheet Functions | |||
| Avoid 0 values in a graph? | Charts and Charting in Excel | |||
| How to be noticed/to avoid equal values in a colum | Excel Worksheet Functions | |||
| Many low values, one high value- how do I avoid skewed chart? | Charts and Charting in Excel | |||
| SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions | |||
Linear Mode
