Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.