![]() |
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