Create chart from List Box

[Brenda]

How do I use a List Box, with the months in it, allowing
the user to click on a month and pull up that particular
chart? Do I have to create several charts and use the
list box as a hyperlink or can I have the chart create
itself?

TIA,
Brenda

 

[Debra Dalgleish]

Jon Peltier has instructions on his web site that may help you:

http://www.geocities.com/jonpeltier/Excel/Charts/ChartByControl.html

 

[Brenda]

Thanks, it was a tremendous help. I am still having some
difficulty, in trying to create a chart based on two list
boxes (eventually to have three list boxes).

Any ideas?

Brenda

 

[Jon Peltier]

Brenda -

What are you trying to select with the different list boxes?

- Jon

 

[Brenda]

Jon:

I have two seperate list boxes, one containing the month
for the report, the other containing the area for the
report. I need to be able to specify the month and the
area, to show several different reports. I'd like to
also be able to show reports with multiple months, to be
able to see the changes in a specific area, over a period
of time. All of these are column charts.

Thanks,
Brenda

 

[Jon Peltier]

Brenda -

If you send me a simplified workbook with a sampling of your data, I'll
see how it can be set up to allow this. Remove the obvious antispam
phrase from my email address.

- Jon