Chart Location

[sumathi]

Hi,

How to specify the location of a chart in a sheet (The
sheet contains 4 charts).The chart location should vary
dynamically depending on the values associated with it.



Thanks and Regards,

Sumathi

 

[Jon Peltier]

Sumathi -

You need to specify the coordinates and dimensions of the chart's parent
chart object, in pixels.

With ActiveChart.Parent '' or With ActiveSheet.ChartObjects(1)
.Top = 50
.Left = 50
.Height = 175
.Width = 225
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______