Disable Fast Chart

[sorrakis01]

Hi,

It's posible to disable (Hide/Unhide) the fast style chart using VBSCript?

Thanks

[m_woolf · Accepted solution]

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

[sorrakis01]

Perfect Michael It works!

Thanks.