Showing Values on Charts

  • Thread starter Thread starter James L
  • Start date Start date
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
 
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
 
Back
Top