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

[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.

 

[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

 

[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

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

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.