Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show percentage data with the % sign on a bar chart? | Charts and Charting in Excel | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |