PDA

View Full Version : Solved: Scale graph absolutely



enfantter
08-13-2008, 03:38 AM
Hi all,

I'm trying to do a part of a macro where i want to resize a graph.
I do a code that sizes the graph in relative terms, but does anybody know how to do it in absolute terms?
/Enfant Terrible

Bob Phillips
08-13-2008, 03:53 AM
What do you mean?

enfantter
08-13-2008, 03:57 AM
Im doing a macro that creates graphs in the right colour - now and want to include a part so they get the right size as well. But i can only figure out a way to change the relative size (eg. make it 50 pct. smaller ) not to change it to absolut size no matter what size the graphs is at the begining.

Bob Phillips
08-13-2008, 07:35 AM
This works fine for me



With ActiveSheet.ChartObjects("Chart 1")

.Height = 200
.Width = 300
End With

enfantter
08-13-2008, 10:52 PM
Ok, i guess then it is just me who is thumbling.
Is it possible to put something like ActiveChart inside the paranthathese?!

enfantter
08-14-2008, 01:48 AM
i know that this is probably too simply but i would need to attach something so this applies to the activechart

Bob Phillips
08-14-2008, 01:55 AM
It is the chartobject that has height, so you have to get the chart parent



With ActiveChart.Parent

.Height = 200
.Width = 300
End With