| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How-to not plot cells with zero value on graphs
Hi,
Depending on the chart type you could have used a formula instead of VBA. =IF(test=0,NA(),test) where test is you complex formula. Cheers Andy bob777 wrote: I had this problem. I wrote a macro that scanned my data and wherever it found a value of zero it deleted the cell contents. They then do not plot on charts. My data values were complex formulas, so I wrote a second macro to reinstate the formulas so that the cells were able to display correct values when the base data changed. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
