Chart origin position/coordinates (VBA)

Visual Basic 6.3, Excel 2007
I have a pivot chart, type xlCylinderColStacked
I would like to know the combination of .ChartArea and .PlotArea attributes (.InsideLeft, .Height, .Top, and so on) that identifies the exact position of the chart origin (i.e. the position of the center of the red circle which I added to the attached chart)
Immagine.JPG
As a second best, it will be appreciated a way to put the green horizontal line at a pre-determined position (now it is at 0.30%, but this value changes at each macro iteration, it may be 0.40% next time, 0.20% the time after the next, etc... value should be readen from another Excel file)

Hi
Welcome to the board

Not sure I understood exactly what you want, but if you want to draw a red circle at the origin activate the chart and try this code:

Please Login or Register  to view this content.

Thanks for your quick reply. It worked but it made me understand I was not clear about my problem
what I really need is the vertical distance between the two red horizontal lines in the upper left corner of the attached image (lines added to make you understand the measure I need). I know the distance depends on the height of the y axes and on the rotation I applied to xlCylinderColStacked, but I can't figure out the formula. Should I re-post with different title?

Immagine2.JPG