Position Chartobjects in Chart sheet

O

ojv

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 where:=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Axes(xlCategory) for a chart-sheet in 2007 2
Problem looping ChartObjects in a Com-dll 0
Chart disappearing in Excel 07 but not in 03 2
Selecting a chart in a worksheet with VBA trouble 2
chart vs. chartobject 3
Is this a bug in excel 2007 charting 9
add a chart in a Add-In 1
Chart Position in VB6 5

Top