Create chart from List Box

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

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

http://www.geocities.com/jonpeltier...tByControl.html

Brenda wrote:
> 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?

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

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

>-----Original Message-----
>Jon Peltier has instructions on his web site that may
help you:
>
>
http://www.geocities.com/jonpeltier...harts/ChartByCo
ntrol.html
>
>Brenda wrote:
>> 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?
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>

Brenda -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Brenda wrote:

> 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
>
>
>>-----Original Message-----
>>Jon Peltier has instructions on his web site that may
>
> help you:
>
>>
>
> http://www.geocities.com/jonpeltier...harts/ChartByCo
> ntrol.html
>
>>Brenda wrote:
>>
>>>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?
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>.
>>

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

>-----Original Message-----
>Brenda -
>
>What are you trying to select with the different list
boxes?
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>http://www.geocities.com/jonpeltier/Excel/index.html
>_______
>
>Brenda wrote:
>
>> 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
>>
>>
>>>-----Original Message-----
>>>Jon Peltier has instructions on his web site that may
>>
>> help you:
>>
>>>
>>
>>
http://www.geocities.com/jonpeltier...harts/ChartByCo
>> ntrol.html
>>
>>>Brenda wrote:
>>>
>>>>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?
>>>
>>>--
>>>Debra Dalgleish
>>>Excel FAQ, Tips & Book List
>>>http://www.contextures.com/tiptech.html
>>>
>>>.
>>>
>
>.
>

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Brenda wrote:

> 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
>
>
>>-----Original Message-----
>>Brenda -
>>
>>What are you trying to select with the different list
>
> boxes?
>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>http://www.geocities.com/jonpeltier/Excel/index.html
>>_______
>>
>>Brenda wrote:
>>
>>
>>>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
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>Jon Peltier has instructions on his web site that may
>>>
>>>help you:
>>>
>>>
>>>>
>>>
>>>
> http://www.geocities.com/jonpeltier...harts/ChartByCo
>
>>>ntrol.html
>>>
>>>
>>>>Brenda wrote:
>>>>
>>>>
>>>>>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?
>>>>
>>>>--
>>>>Debra Dalgleish
>>>>Excel FAQ, Tips & Book List
>>>>http://www.contextures.com/tiptech.html
>>>>
>>>>.
>>>>
>>
>>.
>>