View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
fascal
 
Posts: n/a
Default hiding zero values in charts

Hi,

I followed the directions given to hide zero values in chats and tables in
Excel 2000. I used the chart wizard when i created them. But the zero
values continue to be shown on the chart. For example, I have data for
target values versus actual values for events. The targeted numbers go from
July 2005 - June 2005. The actual data values are from July 2005 - Nov
2005. I used the tools optionschartplot visible cells only.

Any guidance on what I am doing incorrect?