Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 126
Default Dynamic chart title

Hi,
I see several post on how to make dynamic chart titles. When I try to input
= cell-reference, Excel either treats this like text or exits the text box
and selects the cell instead. It does not work like normal cell input. I'm
using Excel 2007. Any clues?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,420
Default Dynamic chart title

You have to enter it in the formula bar after selecting the chart title, not
directly into the chart title.

--
__________________________________
HTH

Bob

"johnny" wrote in message
...
Hi,
I see several post on how to make dynamic chart titles. When I try to
input
= cell-reference, Excel either treats this like text or exits the text box
and selects the cell instead. It does not work like normal cell input. I'm
using Excel 2007. Any clues?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 126
Default Dynamic chart title

Thanks, worked wonders
J

"Bob Phillips" wrote:

You have to enter it in the formula bar after selecting the chart title, not
directly into the chart title.

--
__________________________________
HTH

Bob

"johnny" wrote in message
...
Hi,
I see several post on how to make dynamic chart titles. When I try to
input
= cell-reference, Excel either treats this like text or exits the text box
and selects the cell instead. It does not work like normal cell input. I'm
using Excel 2007. Any clues?




Reply
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
Dynamic Chart Title? Kent McPherson[_2_] Charts and Charting in Excel 6 August 16th 07 08:48 AM
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


All times are GMT +1. The time now is 07:23 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"