How to create a chart that correspond to each other

[David]

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

 

[Debra Dalgleish]

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

http://www.peltiertech.com/Excel/Charts/ChartByControl.html