Can I make a "tab name" the "chart title"?
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. |
Answer: Can I make a "tab name" the "chart title"?
Yes, you can make a tab name the chart title in Excel. Here's how:
If you want to make this process easier, you can create a named range for the tab name and use that in the formula instead of the cell reference. Here's how:
|
Can I make a "tab name" the "chart title"?
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" wrote in message ... 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. |
Can I make a "tab name" the "chart title"?
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" wrote: 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" wrote in message ... 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. |
All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com