ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dynamic chart title (https://www.excelbanter.com/charts-charting-excel/197739-dynamic-chart-title.html)

Johnny

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?

Bob Phillips[_3_]

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?




Johnny

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?






All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com