Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart suppression of zero's
HI, for a chart series of historical data that is not yet populated, I want
to suppress the chart plotting of zero's. The option of plot empty cells as 'not plottted' does not work. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart suppression of zero's
Are the cells empty, or are they the result of a formula returning an empty
string ""? If the latter, replace the "" by NA(). -- David Biddulph "ncalpaperboy" wrote in message ... HI, for a chart series of historical data that is not yet populated, I want to suppress the chart plotting of zero's. The option of plot empty cells as 'not plottted' does not work. Thank you. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart suppression of zero's
Another option would be to make your chart dynamic:
http://www.cellmatrix.net/index.php/...de_zero_values -- John Mansfield http://cellmatrix.net "ncalpaperboy" wrote: HI, for a chart series of historical data that is not yet populated, I want to suppress the chart plotting of zero's. The option of plot empty cells as 'not plottted' does not work. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Suppression of Zeros | Charts and Charting in Excel | |||
Adding error suppression to AVERAGE FUNCTION | Excel Worksheet Functions | |||
Zero Suppression in Excel barcode fonts | Excel Worksheet Functions | |||
zero suppression on opening .xls file | Setting up and Configuration of Excel | |||
Zero Suppression | Excel Discussion (Misc queries) |