Spreadsheet query SharePoint & Chart Layout

[Franklin]

Greetings!

I have a SharePoint list in which I intend to store data. While views in
SharePoint will do in some cases, it is required that I am able to display
the data graphically. At this point I've added the spreadsheet web part to a
page, imported the data from the list using a query, and am now attempting to
setup the chart.

The issue that has arisen is that despite setting up a layout in the
pivotview web part and saving the layout, the layout resets to a default
layout. My theory is that since the spreadsheet is populating the data
through a dynamic query, the pivotview web part is sensing that the data has
changed and therefore resets the layout.

Can anyone confirm or deny the theory or offer a solution to this problem?

 

[Alvin Bruney [MVP]]

This is best answered on the sharepoint newsgroup. The spreadsheet and pivot
table objects in sharepoint are not OWC objects. I'll take a stab at
answering though. In the typical case, settings for web parts are stored and
retrieved as normal. Can you verify that layouts for other web parts are
persisted?

--
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99