Pivot Chart - cannot save changes to data labels or page layout

[Guest]

Good Morning,
I have built a pivot chart from a select query. I initially thought I had
the chart looking like I wanted it to and saved the data. I after further
review I needed to edit the chart title and the page layout for printing and
opened my query in pivot chart view. I made the changes that I needed and
saved the chart, query etc. After closing the query, I re-opened it and the
chart had reverted back to the old page layout and the old title. I found
that I am able to move the chart title, for example from top of page to
bottom of page, and save the changes, however, the text in the title reverts
back to the old text even while the chart title retains its new position.
This is, needless to say, frustrating and eating up clock hours that i dont
have to spare.

Thanks to anyone that can respond.

 

[Guest]

Did you change the name or the caption. The name is the name of the object
and not the text of the display. Caption is the text that is displayed.