Runnning an animated graph using macro

[#1]

hi, i am having many animated graphs in a sheet, and i wanted to run it automaticaly when the sheet is activated.Bookmark is not helping out this issue.Any suggestions is appreciated.

[#2]

Hi nandhini!

Just tick the Autopla y and the chart will automatically play or animate once the sheet is activated. (see below).

Lester

[rustyfishbones]

You can use a Macro from the API Guide

As long as your animated chart is "CH01", if not just change to what it is in the code below

SUB Animate

set chart = ActiveDocument.GetSheetObject("CH01")

set p = chart.GetProperties

p.ChartProperties.AnimationProperties.AutoPlay = true

chart.SetProperties p

END SUB