is it possible list box to a chart in excel 2003 as was in 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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