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 |
All times are GMT +1. The time now is 12:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com