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
|