Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How-to not plot cells with zero value on graphs
Hey! ANyone know how to not plot values if they equal zero in the graphs? Thanks!! keith -- hopeace ------------------------------------------------------------------------ hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009 View this thread: http://www.excelforum.com/showthread...hreadid=487862 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How-to not plot cells with zero value on graphs
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. -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=487862 |
#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 |
Reply |
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) |