LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Bar chart with no zero columns

I have a colums with a hundreds a values and only twenty is real values the
rest is all zero. How do I plot a bar chart showing only the values and omits
the zero values from the chart. My chart is plotting all zero values which
makes it impossible to view. Is there a way of not plotting the zero columns
without filtering the data. I read the previous posts but the NA() allso
shows zero values. Any help would be appreciated. Thanks
 
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
Widening Columns in Chart Hoosierquilt Charts and Charting in Excel 7 May 9th 07 08:50 PM
Merged columns in chart [email protected] Excel Discussion (Misc queries) 0 August 22nd 06 04:01 PM
Chart columns dsharp Charts and Charting in Excel 1 April 22nd 06 04:08 AM
How do I have stacked columns and a reg col. on same chart? Kat Charts and Charting in Excel 2 February 14th 06 09:00 PM
Create stacked columns chart but with 2 columns for each x axis? PSM Charts and Charting in Excel 2 May 7th 05 03:56 PM


All times are GMT +1. The time now is 09:51 AM.

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"