If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to prevent Excel 2003 from automatically change chart type | Oscar II | Charts and Charting | 2 | October 1st, 2005 02:57 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
excel 2000 convert to excel 2003 | cityof | General Discussion | 1 | October 4th, 2004 05:55 AM |
paste excel 2003 chart into powerpoint | Nick F | Powerpoint | 1 | September 14th, 2004 05:12 AM |
Chart Data Labels in Excel 2000 for Windows | Mark Baker | Charts and Charting | 1 | October 17th, 2003 06:29 PM |