Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to display the Chart Name as a Chart Title?
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]. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to display the Chart Name as a Chart Title?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a chart title, but keep the title in the chart | Charts and Charting in Excel | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
How to display a series in chart table and not in the chart? | Charts and Charting in Excel | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |