ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Position Chartobjects in Chart sheet (https://www.excelbanter.com/excel-programming/437126-position-chartobjects-chart-sheet.html)

ojv[_2_]

Position Chartobjects in Chart sheet
 
I have moved from Excel 2003 to 2007. When moving an XY scatter chartobject
from an existing chart sheet to another chartsheet using

Set cho = ActiveSheet.ChartObjects(1)
cho.Chart.Location whe=xlLocationAsObject, name:=chForStore.name

I get an error message saying something like "Dimensions not valid for chart
type".

Further, when having located a number of chartobjects in a chart sheet Itry
to position them nicely. I start at the source Chart sheet ChartArea.Top = 0
and ChartArea.Left = 0 but the charts located in the top row invariably
appear to be 4 units below the Top value. Again in Excel 2003 this never
happened. Any idea why this happens and how it can be corrected


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com