Prev: Min and Max Value Changes
Next: Too hard to do?
From: Cecilia on 15 Apr 2010 16:40
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!!!
From: Jon Peltier on 16 Apr 2010 08:15
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!!!
 | 
Pages: 1
Prev: Min and Max Value Changes
Next: Too hard to do?