Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDE VALUE 0 FROM CHART
I have a table from which I create a chart. This table shows the number of times a certain incident happens. When there is "0" number of incidents on that cell, is it possible for it not to show on the chart.
Sorry if this doesnt make sense, head is starting to nip with this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDE VALUE 0 FROM CHART
Hi Barry,
Am Wed, 27 Nov 2013 07:49:16 -0800 (PST) schrieb Barry Mitchell: I have a table from which I create a chart. This table shows the number of times a certain incident happens. When there is "0" number of incidents on that cell, is it possible for it not to show on the chart. instead of 0 use =NA() Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Hide #N/A in chart | Charts and Charting in Excel | |||
how to hide #N/A in chart | Charts and Charting in Excel | |||
Hide a chart | Charts and Charting in Excel | |||
copy charts & paste as picture, hide chart, size & place same picture as chart | Excel Programming |