Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
is it possible list box to a chart in excel 2003 as was in 2000?
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
is it possible list box to a chart in excel 2003 as was in 2000?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
is it possible list box to a chart in excel 2003 as was in 200
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
is it possible list box to a chart in excel 2003 as was in 200
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userforms in Excel 2003 created in Excel 2000 | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
How can I use Excel 2003 to sit for exams which are in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions |