| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel: Can I change Chart-title/category/value from a sheet-cell?
Changing the "Chart Title", the "Category (X) axis" and the "Value (Y) axis"
via the change of a worksheet-cell would be useful. Does such a utility exist? |
|
#2
|
|||
|
|||
|
Excel: Can I change Chart-title/category/value from a sheet-cell?
It is eay to make an example to do this. You just nee to select the chart
title and then input an formula such as "=Sheet1!A1" in the formulabar. |
|
#3
|
|||
|
|||
|
Excel: Can I change Chart-title/category/value from a sheet-ce
For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1". But for "Chart-title", "Value X" and "Value Y", your reference to "=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1". I hope a newer version of Excel will work in the way you describe. Thanks in advance. "AAA" wrote: It is eay to make an example to do this. You just nee to select the chart title and then input an formula such as "=Sheet1!A1" in the formulabar. |
|
#4
|
|||
|
|||
|
Excel: Can I change Chart-title/category/value from a sheet-ce
Hi,
AAA methods works in all versions since xl97 and possible before but I can not check. He is another explanation. http://www.andypope.info/tips/tip001.htm Cheers Andy femke wrote: For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1". But for "Chart-title", "Value X" and "Value Y", your reference to "=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1". I hope a newer version of Excel will work in the way you describe. Thanks in advance. "AAA" wrote: It is eay to make an example to do this. You just nee to select the chart title and then input an formula such as "=Sheet1!A1" in the formulabar. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
Excel: Can I change Chart-title/category/value from a sheet-ce
Andy,
Thank you for your info. It's working now! "Andy Pope" wrote: Hi, AAA methods works in all versions since xl97 and possible before but I can not check. He is another explanation. http://www.andypope.info/tips/tip001.htm Cheers Andy femke wrote: For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1". But for "Chart-title", "Value X" and "Value Y", your reference to "=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1". I hope a newer version of Excel will work in the way you describe. Thanks in advance. "AAA" wrote: It is eay to make an example to do this. You just nee to select the chart title and then input an formula such as "=Sheet1!A1" in the formulabar. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to prevent Excel 2003 from automatically change chart type | Charts and Charting in Excel | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
| How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions | |||
Hybrid Mode
