S
Steve D
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.
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.