Hi all, I cannot find a way to change the shape of an active chart
Macro recorded of this particluar chart object
But then I will have to keep changing the Chart numbers to make the shape change.Sub ResizeGraph() ActiveSheet.Shapes("Chart 138").ScaleWidth 1.67, msoFalse, msoScaleFromTopLeft ActiveSheet.Shapes("Chart 138").ScaleHeight 1.71, msoFalse, _ msoScaleFromTopLeft End Sub
So in what syntax should I use to make the active Chart (no matter what number they are unless one chart is active) change shape? Thanks in advance
Last edited by unley; 03-24-2010 at 04:17 PM.
I'm using MS Office 2007
With Activechart.parent .Width = .Width * 1.67 .Height = .Height * 1.71 End with
Gee, it looks so simple lol and works well, thank you Andy for your help, much appreciate this
I'm using MS Office 2007
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks