Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hiding Zero Values on Chart
Is it possible to automatically 'ignore' zero values when plotting a chart.
i.e. any data set with a value of zero would simply not be displayed on the chart? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hiding Zero Values on Chart
Are they zero values, or formulas that return zero? If they are zeros,
delete the zeros. If they are formulas, change the formula from =A1 to =IF(A1="",NA(),A1) NA() leaves an error in the cell (#N/A) but doesn't appear on a line or XY chart. You can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kippers" wrote in message ... Is it possible to automatically 'ignore' zero values when plotting a chart. i.e. any data set with a value of zero would simply not be displayed on the chart? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hiding Zero Values on Chart
Jon,
Thanks for the advice- they are simply zero values with no formula attached. However, there are a lot of elements (series) (20-30) so when the graph is generated it has large gaps where zero values exist. I was wonderign if there was a way in which elements or series that have a zero value could be eliminated fromt he graph itself (i.e. the actual series header on the grpah would not even appear and teh graph would show only those series with a value 0?) Cheers, Paul "Jon Peltier" wrote: Are they zero values, or formulas that return zero? If they are zeros, delete the zeros. If they are formulas, change the formula from =A1 to =IF(A1="",NA(),A1) NA() leaves an error in the cell (#N/A) but doesn't appear on a line or XY chart. You can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kippers" wrote in message ... Is it possible to automatically 'ignore' zero values when plotting a chart. i.e. any data set with a value of zero would simply not be displayed on the chart? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hiding Zero Values on Chart
No, it's not that easy nor is it dynamic. You could hide the entire
stretches where there are only zeros, since by default hidden cells are not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kippers" wrote in message ... Jon, Thanks for the advice- they are simply zero values with no formula attached. However, there are a lot of elements (series) (20-30) so when the graph is generated it has large gaps where zero values exist. I was wonderign if there was a way in which elements or series that have a zero value could be eliminated fromt he graph itself (i.e. the actual series header on the grpah would not even appear and teh graph would show only those series with a value 0?) Cheers, Paul "Jon Peltier" wrote: Are they zero values, or formulas that return zero? If they are zeros, delete the zeros. If they are formulas, change the formula from =A1 to =IF(A1="",NA(),A1) NA() leaves an error in the cell (#N/A) but doesn't appear on a line or XY chart. You can use conditional formatting to hide the error. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kippers" wrote in message ... Is it possible to automatically 'ignore' zero values when plotting a chart. i.e. any data set with a value of zero would simply not be displayed on the chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
how can I limit my chart | Charts and Charting in Excel | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |