Chart Location

  • Thread starter Thread starter sumathi
  • Start date Start date
S

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
 
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/
_______
 
Back
Top