Showing Values on Charts

J

James L

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
 
J

Jim Cone

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
 
Top