Can I make a "tab name" the "chart title"?


G

Guest

I am making multiple charts that utilizes a common chart with all the data
represented. As I segregate this data into various subsets and copy charts,
it would be beneficial to have the new charts have as its title the new name
of the tab name I give. Can this be done? Headers use &[Tab] to do this,
but I can't make this work for chart titles and using a header appears to
actually reduce the printed size of my chart.
 
Ad

Advertisements

B

Bernard Liengme

It is the Sheet that has a name; that name is displayed on the tab
This name can be displayed in a cell with the formula
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Let's say this is in cell B1. It will show #VALUE! until you save the
workbook and recalculate it; then it will display the current Sheet name
Then in the chart use Chart Options and add a dummy title ( X will do)
Now double click the title; in the Formula bar type = and then point to the
cell with the formula. This will look like =Sheet!$B$1 but will display the
sheet name
best wishes
 
Ad

Advertisements

G

Guest

An additional option utilizing a macro:

Sub TabNameAsTitle()
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = ActiveSheet.Name
End With
End Sub

--
John Mansfield
http://cellmatrix.net





Bernard Liengme said:
It is the Sheet that has a name; that name is displayed on the tab
This name can be displayed in a cell with the formula
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Let's say this is in cell B1. It will show #VALUE! until you save the
workbook and recalculate it; then it will display the current Sheet name
Then in the chart use Chart Options and add a dummy title ( X will do)
Now double click the title; in the Formula bar type = and then point to the
cell with the formula. This will look like =Sheet!$B$1 but will display the
sheet name
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

CurtG said:
I am making multiple charts that utilizes a common chart with all the data
represented. As I segregate this data into various subsets and copy
charts,
it would be beneficial to have the new charts have as its title the new
name
of the tab name I give. Can this be done? Headers use &[Tab] to do this,
but I can't make this work for chart titles and using a header appears to
actually reduce the printed size of my chart.
 

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

Top