Hello,

I'm wonder if there is a way to create a chart that
correspond to the specific data when using a "Chart
Wizard" or regular charts (similar to pivotchart report).

For example:
State Jan Feb Mar
Alaska 195 195 195
Idaho 596 567 654
Montana 761 724 835

A chart that allow us to select a particular state
(dropdown) and it shows the selected state with its trend
of Jan, Feb, Mar, & so on. Instead of cluster all these
states all together.

Thank you in advance!!!
David

Jon Peltier has instructions for showing selected series in a chart:

http://www.peltiertech.com/Excel/Cha...ByControl.html

David wrote:
> I'm wonder if there is a way to create a chart that
> correspond to the specific data when using a "Chart
> Wizard" or regular charts (similar to pivotchart report).
>
> For example:
> State Jan Feb Mar
> Alaska 195 195 195
> Idaho 596 567 654
> Montana 761 724 835
>
> A chart that allow us to select a particular state
> (dropdown) and it shows the selected state with its trend
> of Jan, Feb, Mar, & so on. Instead of cluster all these
> states all together.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html