Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to name a chart for referencing in VBA? And move it.
I'm using the macro recorder to create a pivot chart. I want to do some of my own stuff like move it to a certain location, however, the macro recorder
classifies it as a Shape, for example: ...chart creation goes here... ActiveChart.ChartArea.Select ActiveSheet.Shapes("Chart30").IncrementLeft -229.5 ActiveSheet.Shapes("Chart30").IncrementTop -154.5 ... I would like to give the chart a name instead of a generic number like the macro recorder assignees (and increments :-( ). Also, how would I take that named chart and move it to a specific location, like a cell reference ("A1" or "P30")? I looked to Chip's page http://www.cpearson.com/excel/codemods.htm but it didn't help me for naming a chart. Toby Erkson Oregon, USA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart referencing | Excel Discussion (Misc queries) | |||
referencing a value from a chart with 3 variables | New Users to Excel | |||
How to draw a line on a chart, and have it move with the chart? | Charts and Charting in Excel | |||
Referencing chart sheets in vba | Charts and Charting in Excel | |||
Formula referencing deleted row (move up automatically) | Excel Worksheet Functions |