| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart Macro
Is there a way to record a macro when creating a chart and use the value of
A1 as the chart title and the value of A2 as the name of the chart. Right now, when I look in the VBA editor the macro has recorded the name as "chart 11" or something like that. I've tried to use ActiveChart.Name = "James" as the name of the chart, but I keep getting an error. Can anyone please help me? Thanks James -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Macro to Update Chart | Charts and Charting in Excel | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Threaded Mode
