LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Negative or zero values cannot be plotted correctly on log charts NTE Charts and Charting in Excel 6 December 11th 05 05:27 AM
Min values in a list of numbers Traima Excel Worksheet Functions 1 August 5th 05 01:32 PM
suppress zero values in line charts? Cruickshank Brothers Charts and Charting in Excel 4 June 12th 05 04:28 AM
Can I add values, labels and percentage for pie charts? coops-eng Charts and Charting in Excel 1 February 1st 05 04:23 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"