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!!!

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!!!