Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I move a chart using a macro?
Hi, all,
I have a nice little macro that creates two charts on several worksheets in a workbook. My problem is that it places one chart right on top of the other. I just need to offset it enough to see both charts, or at least to remind myself that there are two of them there. I tried variations of the "Activechart.parent . . . ." commands I found elsewhere on the site, but I always get the debug screen when I get there. I'm using OFFICE 2007 and Vista. Thank you Jim -- JP Cummings |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I move a chart using a macro?
Assuming you know what cell you want as the top left cell position for the
chart, you can do something like this: Dim chtObj As ChartObject Set chtObj = ActiveSheet.ChartObjects(1) chtObj.Left = Cells(2, 2).Left chtObj.Top = Cells(2, 2).Top and for the 2nd chart, just modify to set its position. If you type "chtObj." (don't forget the period), you will see a set of properties, many of which you can set. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Cummings" wrote in message ... Hi, all, I have a nice little macro that creates two charts on several worksheets in a workbook. My problem is that it places one chart right on top of the other. I just need to offset it enough to see both charts, or at least to remind myself that there are two of them there. I tried variations of the "Activechart.parent . . . ." commands I found elsewhere on the site, but I always get the debug screen when I get there. I'm using OFFICE 2007 and Vista. Thank you Jim -- JP Cummings |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to move to another cell | New Users to Excel | |||
How to draw a line on a chart, and have it move with the chart? | Charts and Charting in Excel | |||
How do i move a chart | Charts and Charting in Excel | |||
Macro to move to next column | Excel Discussion (Misc queries) | |||
Macro - Find a value and then move down | Excel Discussion (Misc queries) |