I have several pivot tables in Access where I've created some calculated totals. I want to create pivot charts from these pivot tables but I cannot seem to get those calculated total into the charts. I'm only seeing where I can do "autocalc" like Sums, averages, etc.
I thought I may have to use Excel charting to get that done. If so, does anyone have any good tutorials on how to use Access queries to create Excel charts and then to have those charts show up in Access?
I thought I may have to use Excel charting to get that done. If so, does anyone have any good tutorials on how to use Access queries to create Excel charts and then to have those charts show up in Access?