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