0

Goal: I am trying to build a dashboard in excel using one pivot-table & multiple charts based on that pivot-table. The pivot-table have to have a access query data link.

Problem: Currently I build a data link for every chart because I cant find a way to build multiple charts of one pivot table. Excels bloats like a balloon when I do this and takes really long to save any changes not to mention refreshing the data... Is there a better way of doing this? What do you guys use to build reports in big databases?

Side Note: I realize Access also got pivots but they are limited in features and unstable with lots of data. Also I have seen similar questions on this site but with limited or lacking answers.

Rhdr
  • 387
  • 4
  • 22

1 Answers1

0

Found an answer here: https://www.youtube.com/watch?v=_nfJLz5rVmo

Basically when working with external data you should link "un-pivoted" data then create 2 pivot tables based on that data in a new excel sheet. Then on those 2 new pivot tables you can then build 2 charts which are linked but can have different layouts!

Rhdr
  • 387
  • 4
  • 22