Pivot Chart not saving format changes

[emorris1000]

This is driving me up the wall. I know I've had this problem before, and I know that (somehow) I fixed it, but I have no idea how.

I have a pivot chart in a form in my database, and it needs some formatting changes:

- X-Axis needs tick marks/labes spread out to 10 spots, default is 1 (which, by the way, is pretty dumb in and of itself)

-I want a legend

-I am going to hide the fields that the user doesn't need to pivot on (you do this by changing color to white and border to clear.)

Anyways, easy changes, nothing fancy. It takes the chart from looking like something made by a highschool kid to something I can distribute at work. But every time I make these formatting changes, the next time I open the form everything has reverted to default.

I'm tempted to just use a standard graph with some dropdowns for filtering, but the ability to exclude certain series without any work on my part is just too good to pass up.

Anyone know how to get around this problem? Also does anyone have any idea why in the world they would design it like this? It seems phenomenally dumb to have the formatting only adjustable by the end user and not the developer :banghead:

 

[TomLoder]

I have the opposite problem - And wish I could solve it....

I have formatted the Pivot Charts in the pivot chart view and got them looking really good, however if they are then opened by a user and the users fiddles with anything it saves the changes on top of my pre built pivot charts. This is a real pain as the data the user sees may have only one series and therefore looses all the properties for the other series.

I have to use VBA to make a copy of the Pivpot Chart form before opening it for the user, However this causes problems if the Pivot chart has a module with VBA in it.

Anybody know how to make the Pivot chart properties READ ONLY or at least Unsaveable! (I'm happy for the user to change them, I just don't want those changes saved permanenetly to the Access file.)

 

[fairbud]

I've had some success with this initial problem by switching into design view, saving and then going back into pivotchart view. This seems to commit the changes.

 

[boerbende]

Looks similar to how difficult it is to save modified settings in a subform. After 3 years, I think I can reproduce it, but I still don't know why and how.

But something different. Why using pivots in Access? As far as I remember this change thing was the first reason for me to stop with it. When I want to do something with Pivot, I open from Access an Excel which is linked to the access database.
To create an Excel based on Access data, select Data, from Access, then you select a database, the tables (or query you prepared) and you can select between tableview, or pivot etc. I like best Excel, it is much more powerful with pivots, it actually stores the modifications and ... to prevent people from changing it ... just make the file readonly