This should help.
http://www.andypope.info/tips/tip001.htm

Stuck with Excel wrote:
Thanks, that helps!

Just wondering - i want to link text from another spreadsheet into the chart
so that when the selection is changed, it is then possible to change to chart
title. I have the cell reference ready just cannot remember how to link it
into the chart.

Many thanks

Stuck!

"Andy Pope" wrote:


Hi,

No you can still add controls from the Forms toolbar to chart sheets.
Perhaps you are using controls from the Control toolbar.

Cheers
Andy

Stuck with Excel wrote:

In excel 2000 it was possible to add a combo/list drop down box onto a chart
so that you could select which data you wanted to appear on a chart without
creating multiple charts. I cannot seem to get this to work in 2003? Has
the ability been removed?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info