LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
dot dot is offline
external usenet poster
 
Posts: 29
Default Don't Show Zero Data

Hi All

Is there a way to not show data on a bar chart if the data is =to Zero. (e.g.)
Name: Amount:

Almond Cream Cake 0
Apple Strudel 3
Asian Spice 0
Baby Powder 5
Bed of Roses 0
Berry Mulbery 0
Bird of Paradise 6
Butterfly Kisses 4
Buttery French Vanilla 0

I have about 65 rows of data I just didn't put it all here. When I use the
chart wizard it shows all the names even if the amount is 0.(Cluttered) I
just want to chart names that have numbers next to them that are greater than
2. The numbers change weekly. Can this be done?

 
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
How do I show percentage data with the % sign on a bar chart? Tanja Srebotnjak Charts and Charting in Excel 1 September 20th 06 08:52 PM
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 06:23 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"