Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
This works like a charm. Thanks a lot