How do I create a drop down menu in a chart

On Thu, 5 Jul 2007, in microsoft.public.excel.charting,
richard said:

How do I create a drop down menu in a chart

Use the Forms toolbar

(and not the Control Toolbox toolbar: I had terrible trouble trying to
work out what I was doing wrong before I finally worked out they were
different)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi Richard

I have a worked out example on my Excel / soccer website. But mind you, the
site is in Dutch... Thus I will guide you.

Visit http://www.wimgielis.be, choose Excel in the left navigation bar, then
Voorbeeldbestanden (left bar), then on that page, search for Evolutiegrafiek.
Download an Excel file by clicking the picture.

The chart is on the second tab. I uses a forms listbox. Give it a whirl and
try to understand where the data come from. I used a few named ranges on the
first tab.

Good luck with it.

Wigi