API to get a setting "Plot Values Inside Segments"

[Oleg_Troyansky]

Hi all!

I need to know in a macro whether a chart has the setting "Plot Values Inside Segments" set to "on" or "off". I've been searching the API guide, but no luck... Wondering if anyone knows whether such API exists...

thanks!

[Anonymous · Accepted solution]

I think it is NumbersOnDataPointsLocation

[Oleg_Troyansky]

Yep, that's it, just found it myself and wanted to update the thread:

rem Plots numbers inside segments
set chart=ActiveDocument.GetSheetObject("CH02")
set p = chart.GetProperties
p.ChartProperties.NumbersOnDataPointsLocation = 1 '1 - Inside segments, O - On top
chart.SetProperties p

thanks Michael!