Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Problems(Charts)
I was trying to make charts for values bieng calculated using
formulae. How can I prevent excel from taking values as Zero if no value is given in the cells where primary data is given. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Problems(Charts)
Select your chart, then Tools/ Options/ Chart/ Plot empy cells as:
and choose Not plotted, or Interpolated, not Zeroes. If the cell isn't empty, but the result of a formula returning "", for example, then replace the "" in the formula by NA() -- David Biddulph wrote in message ... I was trying to make charts for values bieng calculated using formulae. How can I prevent excel from taking values as Zero if no value is given in the cells where primary data is given. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Are Users Experiencing Problems with Charts? | Charts and Charting in Excel | |||
Problems with Charts | Excel Discussion (Misc queries) | |||
Formatting Problems with Pivot Charts | Excel Discussion (Misc queries) | |||
Problems with Stacked Bar charts | Charts and Charting in Excel | |||
Layout problems with org charts in Excel | Charts and Charting in Excel |