Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default Dynamic Chart title and text formula?

I have a series of charts that I'd like to create a title for using the left
function.

I'd like the chart titles to be the result of =LEFT(B7,7). I know how to
pull the full contents of a cell but thought of saving a step to avoid doing
this as a separate cell formula and point the chart title to that. Any ideas?

Thanks!!!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Dynamic Chart title and text formula?

The formulas in the chart's text elements can only be link formulas.
Splurge and use the extra cell, it doesn't cost much.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/15/2010 4:40 PM, Cecilia wrote:
I have a series of charts that I'd like to create a title for using the left
function.

I'd like the chart titles to be the result of =LEFT(B7,7). I know how to
pull the full contents of a cell but thought of saving a step to avoid doing
this as a separate cell formula and point the chart title to that. Any ideas?

Thanks!!!

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 With 3D Stacked Column Chart Thomas M. Charts and Charting in Excel 2 March 23rd 09 04:14 PM
Dynamic chart title johnny Charts and Charting in Excel 2 August 6th 08 09:54 AM
Dynamic Chart Title? Kent McPherson[_2_] Charts and Charting in Excel 6 August 16th 07 08:48 AM
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 08:08 PM.

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

About Us

"It's about Microsoft Excel"