Displaying PivotChart on desktop

[BillS]

I have an Access Queery that I view in PivotChart form. I
want to view this PivotChart as a desktop item that I can
refresh at will and see 'real-time' data.

Anyone know how i can do this?

I have tried 'saving as...' html/xml - to no avail...

(BTW: I'm using Access Beta 2003)

Bill.

 

[[MVP] S. Clark]

What do you mean by, "view this PivotChart as a desktop item".


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Bill]

I use 'Active Desktop' and would like to see my
PivotChart in a Window on the Desktop.

Bill.

 

[[MVP] S. Clark]

Ok, but I don't know if you're gonna like this...

1. Open FrontPage and create a new HTML page.
2. From the Main menu, choose Insert / Web Component
3. Left Pane: Click on Spreadsheets and Chart
4. Right Pane: Click on Office Pivot Table
5. After control is placed, click on it to select the data sources.
6. Save the page anywhere.
7. Close FrontPage

Next, return to your Active Desktop settings and browse to select the new
HTML file to add to your desktop.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-