Create chart from List Box

  • Thread starter Thread starter Brenda
  • Start date Start date
B

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
 
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:

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
 
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
 
Back
Top