Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excluding Entire Data Fields in a Graph
I am trying to figure this out and there are a lot of other posts that skirt
around this subject but none that specifically address my needs. I am using a bar graph and lets say for example I am using a chart of fruit picking that looks like this: Jun Jul Aug Sep Lemons 10 15 18 7 Apples 5 10 15 29 Oranges 9 20 17 33 Now my bar graph shows three bars labeled Lemons, Apples and Oranges. I have a drop down box where I can choose "Citrus" or "All Fruit" When I choose citrus the entire row of Apples in my table turns to #N/A including the word Apples. Now my bar graph shows 2 bars but 3 labels Lemons, #N/A and Oranges and there is a gap between the 2 bars. How do I completely ignore the #N/A row? Sometimes my graph should have 2 bars and sometimes 3 bars. Can the graph autofit to account for this? Any help is much appreciated. -- Thank You, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Bar Graph - Values from one cell, data from another FAST formating | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |