We have a Excel Sheet which has got a Chart that is generated from an Analysis DB (Excel connects to Analysis DB with a particular credential which is setup when connecting to Analysis DB via Excel).
We need to show this on a SharePoint page. Please advice on step by step best practice.
Here is what I do:
Configure excel service application -> Trusted file location
Configure secure store application (this is needed to enable data refresh via excel web access webpart)
Add excel document to a doc library
Add excel web access webpart to sharepoint page and specify the path to this doc.