Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to make the y-axis of an embedded chart line up with the edge of
a column. However I'm struggling to do so because I'm not sure of the relationships between: - activechart.parent.* - activechart.chartarea.* - activechart.plotarea.* - activechart.plotarea.inside* where * denotes a property such as left, width, top or height. I know that the lower 3 properties are referenced from the parent object position, but other than that I can't get the axis to sit where I want it. It's always *slightly* off. I'm also struggling to determine which of these properties is read-only. I'm using the chartobjects.add() command to add an area plot with the ..parent dimensions that I'd like and then I'm removing *all* axes information, including the axial lines themselves. Thus the plot is essentially a floating area. There are multiple instances of these floating areas arranged vertically, and I'd like them to all line up properly with column edges such that I can use columns to delineate years (they are all time series). Any explanations on how these properties relate to each other / are calculated during chart resizing, such that I can control the position of the axes, would be great. Cheers, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting chart title from Embedded Excel Chart in PowerPoint | Excel Programming | |||
Format alignment for XLS 2007 in the chart data | Excel Discussion (Misc queries) | |||
Chart Axis Alignment | Excel Programming | |||
Embedded Chart Versus Chart - ShowDetail Issue | Charts and Charting in Excel | |||
Chart DataLabel Alignment / Word Wrap | Excel Programming |