Change the look of a gauge chart

[hfkchristian]

Hi all

I try to make a macro to change the look of a gauge chart. I tried this, but it's nok working:

set chart = ActiveDocument.GetSheetObject("GaugeChart")
set prop = chart.GetProperties
prop.GaugeChartMode =0
chart.SetProperties prop

It generates an error on the line prop.gaugechartmode=0. Do you have any idea why it's not working?

[sebastianlettner · Accepted solution]

Hi,

this should work.

set chart = ActiveDocument.GetSheetObject("GaugeChart")

set prop = chart.GetProperties

set gProp = prop.ChartProperties

gProp.GaugeChartMode = 0

chart.SetProperties prop

Regards

Sebastian Lettner

[hfkchristian]

This works like a charm. Thanks a lot