Hi,
I'm redesigning a Excel workbook I have which does Pivot Charts from an SQL Server data source and looking for advice on the best methods (pros and cons). This is for Excel 2013 and SQLServer 2014.
Some of the things I have considered are;
1. Create a Pivot Chart directly from a server table
2. Create a table directly from a server table and then Pivot chart these inside Excel
3. Create a Cross Tab View in SQL and connect to this and chart directly in Excel
4. Power Pivot or Power View. I don't have any experience with these yet.
The kind of discussion of interest around the above is.
- What is the most efficient from a file size perspective?
- Can I make 1 connection and have serveral charts doing different things run off it?
- Anything else of interest
Thanks in advance
- Moved by Fei XueMicrosoft contingent staff 5 hours 14 minutes ago