Need advice about dashboards

[ria.arora]

Hi Pat,

Thanks. I'm pretty much new in this that's why asking experts help. Once you can provide some guidance then I can take it from there. Need some sample code e.g. using different queries coping that into different cells.

Tried to find the code but did not get any useful sample code.

 

[Pat Hartman]

I don't have any examples that do what you need. I found an article from MS that should give you a start and also a database created by Roger.

 

[dallton]

I would create a pivot table for each of the 13. Point the pivots to an external data source (Access). Then create charts and graphs from each pivot. To update simply refresh the pivots.