Saving a PivotChart view in a form

[Bill Murphy]

I have a subform containing a PivotChart view. The user can change the view
by filtering it with the included dropdowns, and can change the chart type.
Is there a way to save the current view for the user on their PC (the data
is in an mdb file on a network server), so that when they later re-open the
form they will get the view that existed when the form was closed?

I'm running OWC 10 on a Windows 2000 PC and also on a Windows XP PC.

Bill

 

[Thao Moua [ms]]

To save the current state of a Chart/PivotChart, save the
following property to a file or wherever you want to.

'Chartspace.XmlData is a string value
strChartState = Chartspace.XmlData

To restore the state of a chartspace object later, do

Chartspace.XmlData = strChartState

-tm