| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro for chart title
I need a macro to link a chart title to a cell or range
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Macro for chart title
Hi,
Macro recorder is good for things like this, assuming not xl2007. You can only link to 1 cell. If you have multiple cells you will need to concatenate them in a single cell and link to that. ' linked to A1 ActiveChart.ChartTitle.Text ="=Sheet1!R1C1" Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "T-Man" wrote in message ... I need a macro to link a chart title to a cell or range |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Macro for chart title
Do you need a macro, or are you unfamiliar with the manual way?
Select the axis title, chart title, data label, or shape, type = in the formula bar, then click on the cell. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "T-Man" wrote in message ... I need a macro to link a chart title to a cell or range |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using macro to set chart title with a variable month | Excel Discussion (Misc queries) | |||
| Chart title | Charts and Charting in Excel | |||
| Chart title | 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 | |||
Linear Mode
