Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
It's posible to disable (Hide/Unhide) the fast style chart using VBSCript?
Thanks
If you don't want some users to see the fast change ican, why not create two charts, one with fst change and one without. Then Hide or Show the charts with a variable?
I found this in the API Guide:
set chart = ActiveDocument.Sheets("Main").CreateBarChart
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set p = chart.GetProperties
p.GraphLayout.FastChange.Bar = true
p.GraphLayout.FastChange.Line = true
p.GraphLayout.FastChange.Combo = true
p.GraphLayout.FastChange.Pie = true
p.GraphLayout.FastChange.Scatter = false
p.GraphLayout.FastChange.Straight = false
p.GraphLayout.FastChange.Pivot = false
p.ChartProperties.FastChangeInChart = true
chart.SetProperties p
chart.SetChartType 4 'line
If you don't want some users to see the fast change ican, why not create two charts, one with fst change and one without. Then Hide or Show the charts with a variable?
I found this in the API Guide:
set chart = ActiveDocument.Sheets("Main").CreateBarChart
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set p = chart.GetProperties
p.GraphLayout.FastChange.Bar = true
p.GraphLayout.FastChange.Line = true
p.GraphLayout.FastChange.Combo = true
p.GraphLayout.FastChange.Pie = true
p.GraphLayout.FastChange.Scatter = false
p.GraphLayout.FastChange.Straight = false
p.GraphLayout.FastChange.Pivot = false
p.ChartProperties.FastChangeInChart = true
chart.SetProperties p
chart.SetChartType 4 'line
Perfect Michael It works!
Thanks.