Pivot Chart

  • Thread starter Thread starter lsl
  • Start date Start date
L

lsl

I have a 900,000 record database in Access and I use EXCEL pivot chart to
query the database. It works wonderfully, except when I add additional
fields to the database and I need to add these fields in the pivot chart, I
have to start all over again.

Isn't there a quick way to add a field to the pivot chart query ?

Appreciate reply to (e-mail address removed)
 
Hi lsl,

Go to the pivot table wizard, hit the back button a couple
of times, click the get Data button. You are now in Microsoft
Query. Just drag the fields you need to the results pane...
 
Thanks.
When I am in the pivot chart and click the pivot table wizard, the BACK
button is greyed out.

something wrong with my EXCEL?
 
Back
Top