View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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