Showing Values on Charts
 

Hello,

Can anyone help? I have a large table in excel that i am
charting. The problem is that i only want to show the
headings that have values and not show the zero value
headings. Is there a way of doing this?

Thanks very much in advance.

James

Showing Values on Charts
 

James,

From the Excel vba help file...

'This example sets Microsoft Excel to not plot blank cells in Chart1.
Charts("Chart1").DisplayBlanksAs = xlNotPlotted

Regards,
Jim Cone
San Francisco, CA

"James L" wrote in message
...
Hello,
Can anyone help? I have a large table in excel that i am
charting. The problem is that i only want to show the
headings that have values and not show the zero value
headings. Is there a way of doing this?
Thanks very much in advance.
James