mridul_kapoor
New Member
- Joined
- Nov 22, 2010
- Messages
- 24
Hi,
Here is my code which I am using to fix the location, height and width of the chart.
Now the problem I am facing is with function "cells()" which is working fine on excel 2010 but somehow it is giving error on excel 2007.
can some1 tell me what wrong m I doing?
or any other way to fix the location, height and width of chart??
ps: I have to display 4 chart on the same screen , keeping 1 at every 4 corners and also height n width being half of what the screen size is.
Thanks in advance
Here is my code which I am using to fix the location, height and width of the chart.
Code:
ActiveChart.ChartArea.Select
ActiveSheet.Shapes("CHART_XY_1").Left = Cells(1, 1).Left
ActiveSheet.Shapes("CHART_XY_1").Top = Cells(1, 12).Top
ActiveChart.Parent.Width = Cells(1, 13).Left - Cells(1, 1).Left
ActiveChart.Parent.Height = Cells(19, 1).Top - Cells(1, 1).Top
Now the problem I am facing is with function "cells()" which is working fine on excel 2010 but somehow it is giving error on excel 2007.
can some1 tell me what wrong m I doing?
or any other way to fix the location, height and width of chart??
ps: I have to display 4 chart on the same screen , keeping 1 at every 4 corners and also height n width being half of what the screen size is.
Thanks in advance