Dynamic Chart title and text formula?

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

Jon Peltier

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

Unreadable text when viewing organization chart in Web version of Visio 365 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Doughnut Chart linked with the slicer in the pivot table 0
Move Chart with Text 0
Paste Link and Link Text From Browser to Word 0
Remove title bar and phase bar by default on swimlane 0
Dynamic Chart Title With 3D Stacked Column Chart 2
Chart SERIES OFFSET 5

Top