Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. The problem is that I can create the chart properly using the pivot drop zones in design mode but when I save and re-open, the value I placed in the data area has 'disappeared' from the chart. Any ideas?

Design Mode

After closing and re-opening

share|improve this question

Yes, very irritating. By trial and error I found I could save the chart with another name, different from the underlying query. That seems to work, it first opens up as a table of the underlying query and then I right click the 'tab' (my access windows are tabbed) and select the pivot chart icon. Hey presto !

share|improve this answer

I have found that you can also view in SQL & overwrite the semicolon & then save it will save with your updated pivot chart settings

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .