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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Chart Title With 3D Stacked Column Chart 2
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Really dynamic monthly chart title 1
Dynamic chart title 2
Chart SERIES OFFSET 3
Change Series Formulas for all charts on worksheet 4
How to display the Chart Name as a Chart Title? 1
How to hide a chart title, but keep the title in the chart 1

Back
Top