Filtering Chart Data from the Legend?

[mike]

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]

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