lcpx
06-21-2006, 09:55 AM
In excel, how can change the position and size of a pie VBA generated chart with VBA code.
Basically I wanted to create 7 charts based on the raw data in the same worksheet. There is no problem on creating the charts by using Charts.Add method in VBA, but once the chart has been created, I couldn?t change the position and the size of them via VBA code because I don?t know the name of those charts and failed to find it from Excel manual.
It seems excel would give a object name automatically when a chart object has been created.
I've been stucked for the whole day and couldn't find a solution. Thanks very much for your time and help.
Basically I wanted to create 7 charts based on the raw data in the same worksheet. There is no problem on creating the charts by using Charts.Add method in VBA, but once the chart has been created, I couldn?t change the position and the size of them via VBA code because I don?t know the name of those charts and failed to find it from Excel manual.
It seems excel would give a object name automatically when a chart object has been created.
I've been stucked for the whole day and couldn't find a solution. Thanks very much for your time and help.