How do I create a drop down menu in a chart

[richard]

How do I create a drop down menu in a chart

 

[Del Cotter]

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)

 

[Wigi]

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