Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
HOW DO I TRANSFER INFO FROM POSITION CHART TO A SCHEDULE SHEET? | Excel Worksheet Functions | |||
Activate ChartObjects on protected sheet?? | Excel Programming | |||
How to export all chartobjects in a sheet to powerpoint (creating a new ppt file) as pictures? | Charts and Charting in Excel | |||
Changing chart title changes position of chart | Excel Programming |