Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.