Getting position of datapoint in stacked column chart

[Holger Gerths]

Hi,

any idea how to get the exact position of datapoints in a stacked column
chart?

Thanks,
Holger.

 

[Jon Peltier]

Holger -

The answer to this depends on what you need to do. Often you don't need
the coordinates, because a simpler approach can get you where you need
to go.

- Jon

 

[Holger Gerths]

I am (VBA-) developing a chart generator which auto-formats and scales the
chart
whith user defined.
I need to draw vertical lines with "anyChart.Lines.Add ..." between two
column stacks.
The next but unexact position I can get is the datalabel's.

 

[Jon Peltier]

Holger -

Make a combination chart with an XY series added to your column chart.
Put the XY series points along the bottom axis where you want your
lines, and use positive error bars to draw the lines emanating from
these points. Hide the points by using no line and no marker. For more info:

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

- Jon