Dynamic Chart title and text formula?

  • Thread starter Thread starter Cecilia
  • Start date Start date
C

Cecilia

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
 
Back
Top