Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a variety of tables in excel that sum approx 20 sheets but
occasionally these have a zero value. The graphs link off these tables and show drops to zero on these occurences. How do I get the graph to ignore the zero values. The source table formula is too long to put an if arguement in. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function: Ignore Mimimum and Maximum Values | Excel Worksheet Functions | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
ignore missing values while ploting graph | Excel Discussion (Misc queries) | |||
Removing 0 or none 0 values from graphs | Charts and Charting in Excel |