How to display the Chart Name as a Chart Title?

E

EAS

Is there a formula or way to display the Chart Name as a Chart Title. For
example if I am going to print a worksheet, I can print the Sheet name using
a header formula &[TAB].
 
H

Héctor Miguel

hi, !
Is there a formula or way to display the Chart Name as a Chart Title.
For example if I am going to print a worksheet, I can print the Sheet name using a header formula &[TAB].
Click to expand...

put the name of the chart in a cell and "link" the chart title to that cell
(selecting the chart title and IN FORMULA BAR put '=' and point the cell)

to get the name of the chart in a cell...

op1: (vba) worksheets(1).chartobjects(1).name

op2: using xl4-macro functions
=> create/define/... a named formula and *call* this name in "the cell"
name formula (to get the chart name in local language)
miChart1 =index(get.document(42,get.workbook(38+0*now())),1)

formula (to get the chart name in english)
=get.object(51,index(get.document(42,get.workbook(38+0*now())),1))

note the "index(...,1)" it is assumed the chart is the *first* embedded object in the worksheet
and... *IF* you assign the chart name by code, either named-forumula returns the same

hth,
hector.
 

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

How to create a bubble chart with more than 2 variables 0
Can I make a "tab name" the "chart title"? (question on this) 2
Displaying content of a cell somewhere on the chart 1
Dynamic Chart title and text formula? 1
Dynamic Chart Title With 3D Stacked Column Chart 2
Chart Title Using Autofilter Selection 6
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Dynamic Chart Formula Question 5

Top