Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
IncrementTop and IncrementLeft can have unexpected results, like if the
chart is created in a sheet with a different freeze panes configuration or a window of a different size. Instead of these with relative distances, use ..Top and .Left with absolute references. More info: http://peltiertech.com/Excel/ChartsH...oveAChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "jdub765" wrote in message ... omg. I found an easy solution. I found the "Record Macro" function in Excel. lol I clicked on "Relative Reference", moved the chart, and then looked at the resulting code. Then I changed the code a little to fit what I needed and I came up with this: With ActiveSheet.Shapes("Chart 1") .IncrementLeft -25.5 .IncrementTop 50.25 End With And it works!! WOOHOO! Thanks for your help Jon Peltier! It helped me understand what was going on a little more so that I could edit the code ;) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
???How to set chart position | Excel Programming | |||
How to set the chart position exactly? | Charts and Charting in Excel | |||
Changing chart title changes position of chart | Excel Programming | |||
Position chart | Excel Programming |