Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminate zero value cells in an EXCEL chart
How do I eliminate zero value cells in an EXCEL chart? I want to create a
chart that don´t plot empty and zero value cells. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminate zero value cells in an EXCEL chart
If the values are coming from another range using formula links, instead of
the links looking like this: =Sheet1!A1 make them look like this: =IF(Sheet1!A10,Sheet1!A1,NA()) The NA() turns into an #N/A error in the cell, which you can hide using conditional formatting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mário Lopes" <Mário wrote in message ... How do I eliminate zero value cells in an EXCEL chart? I want to create a chart that don´t plot empty and zero value cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
eliminate zero value cells from a chart in Excel | Charts and Charting in Excel | |||
Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel |