Automatic chart title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a chart format that will automatically use the name of series 1
as the title when creating the chart?
 
You can format the chart title so it displays whatever is in a particular
cell. When going through the chart creation wizard, for title just type in
"title". Then when the chart is displayed, click into the chart title, and
then in the formula bar type "=" and then click on the cell with the series
name in it. This could be developed much further by writing a formula that is
more descriptive and pointing the title to that cell.
 

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

Chart SERIES OFFSET 3
Dynamic Chart title and text formula? 1
Dynamic Chart Title With 3D Stacked Column Chart 2
How to create a bubble chart with more than 2 variables 0
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Change Series Formulas for all charts on worksheet 4
How do I change the size of a chart title box? 2
Odd Chart Format Results 1

Back
Top