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].
 
Ad

Advertisements

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

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

Top