LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Dynamic Chart Title?

Hi,

You can link chart titles to a cell in Excel. In fact you can link Chart,
Axis and Data labels to cells.
http://www.andypope.info/tips/tip001.htm

If the text you want to display comes from multiple cells then use a helper
cell and formula, such as CONCATENATE, to build the text you want displayed
in a single cell.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"bgrubbs" wrote in message
...
Kent,
I think you are asking about updating the chart title, not just a series
title. In Excel 2003, you cannot link chart titles to cells.
What I have done in the past is to create another data series with the
series title linked to another cell. Then I make the data series format
so
that it is blank. Then the graphs' legend can be moved near the title and
it
looks like it is part of the title. Of course if you have multiple items
you
are graphing and the legend is a key part of the graph this may not work
to
your liking.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I would like to format a dynamic chart title fayiama Charts and Charting in Excel 1 February 15th 06 02:12 PM
Automation of Dynamic Chart Title and legend changes Boon8888 Charts and Charting in Excel 1 February 3rd 06 11:00 PM
Dynamic updating of chart title gerok Charts and Charting in Excel 2 September 14th 05 07:28 AM
dynamic chart title text cwinters Excel Discussion (Misc queries) 2 June 9th 05 08:31 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"