I'm using Excel 2007. I have a simple column chart that counts
widgets by year. There are 10 different sorts of widgets. My
question is, is there a way where I can easily select which widgets I
want to display on the chart? In other words, if My legend looked
like this..
Widget A
Widget B
Widget C
Widget D
Widget E
etc....
I would like the ability to select say, Widget A and Widget C and have
the graph automatically update. Does anyone know if this is possible
in Excel 2007?
Thanks!
Mike
Pete_UK - 17 Apr 2008 23:31 GMT
You could apply a custom autofilter over that range and select Widget
A OR Widget C - the other categories will be hidden both from view and
on your graph.
Hope this helps.
Pete
> I'm using Excel 2007. I have a simple column chart that counts
> widgets by year. There are 10 different sorts of widgets. My
[quoted text clipped - 15 lines]
> Thanks!
> Mike