Hi,
I have a list of data that contains multiple groups I am trying to
create a graph that will show only the group that the user selects from a
dropdown box. The data looks like this:

Group Item Data
A 1 100
A 2 120
A 3 130
B 4 75
B 5 62
B 6 110

The drop down box shows A or B, if the user selects A the graph should show
3 bars named 1, 2 and 3. If the user selects B the graph should show 3 bars
named 4, 5 and 6.

Any ideas how I can achieve this?

--
Thank You,
Steve

Hi,

Have a look at Jon Peltier's example of charting off of control choices.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

Steve D wrote:
Hi,
I have a list of data that contains multiple groups I am trying to
create a graph that will show only the group that the user selects from a
dropdown box. The data looks like this:

Group Item Data
A 1 100
A 2 120
A 3 130
B 4 75
B 5 62
B 6 110

The drop down box shows A or B, if the user selects A the graph should show
3 bars named 1, 2 and 3. If the user selects B the graph should show 3 bars
named 4, 5 and 6.

Any ideas how I can achieve this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info