Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to Create Gauge Chart using macro with min gauge setting to 0.5 and Max Gauge Setting to 1.2 and Segment 2 lowerbond with Expression
You could create this and adjust the properties with code (examples from APIGuide.qvw) like this:
set Graph = ActiveDocument.Sheets("Main").CreateGaugeChart
Graph.AddExpression "sum(Amount)"
set chart = ActiveDocument.GetSheetObject("CH01")
set gp = chart.GetProperties
set gs = gp.ChartProperties.GaugeSettings.GaugeSegments
for i = 0 to gs.Count-1
gs.Item(i).Name.v = i
next
chart.SetProperties gp
But why do you want create this per macro? If you need some flexibilities you could use conditions and variables within the chart to meet other requirements.
- Marcus
Do not make the same topic multiple times. It is considered spamming.
Create Gauge Chart Using Macro