Excel Dashboard for large set of data

[rajesh.pu]

i've assigned to create a excel dashboard, couple of interactive charts and business insights. There should be many filters included in the charts and reports


the data volume is so huge,like 200K rows, 121 columns.


please suggest what would be the better approach to develop this dashboard. i thought of pivot table and graphs. the file size will be so high, that i cant share to my client.


kindly suggest

 

[Montrey]

Create a separate file with your data and calculations. Copy of the calculated data and paste-value it into a new workbook. Then create your graphs from there.