Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic updating of chart title
Hello! I have a spreadsheet containing data for one entire year. From this I extract data and present them in a weekly chart. By selecting a week number, the data is loaded to the chart. I also want the week number to apear in the chart (e.g. in the title ). How can I make that happen? Thanks in advance -- gerok ------------------------------------------------------------------------ gerok's Profile: http://www.excelforum.com/member.php...fo&userid=6637 View this thread: http://www.excelforum.com/showthread...hreadid=466756 |
#2
|
|||
|
|||
Hi,
You can link the chart title to a cell, http://www.andypope.info/tips/tip001.htm Cheers Andy gerok wrote: Hello! I have a spreadsheet containing data for one entire year. From this I extract data and present them in a weekly chart. By selecting a week number, the data is loaded to the chart. I also want the week number to apear in the chart (e.g. in the title ). How can I make that happen? Thanks in advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
To Andy Pope: Thank you very much for a very good and easy solution! :) Regards Georg Rokne -- gerok ------------------------------------------------------------------------ gerok's Profile: http://www.excelforum.com/member.php...fo&userid=6637 View this thread: http://www.excelforum.com/showthread...hreadid=466756 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
dynamic chart title text | Excel Discussion (Misc queries) | |||
Urgent Chart Questions | Excel Discussion (Misc queries) |