Hello Excel Experts,
We need dynamic interactive Dashboard template in Excel with a Custom Left Pane to give Slicers and Search functions and a Custom Top Menu.
The Dashboard and Excel Addin should be compatible with Excel 2003, 2007 and 2010.
Raw Datasheet will be in Excel file itself. ( optional - a local db probably - phase2 work)
There are 5 Dashboard sheets and one Pivot Report Sheet.
6-7 Charts and Filtered data in bottom in each dashboard sheets (Charts are mostly replications. )
One Control Sheet where flexible configuration of dashboard is saved.
Optional : Apart from Slicers and Search function, ideally we would want All charts and Table in one Active Dashboard Sheet to be in relationship with each other. That is&#133;.there is a Filter function, so clicking one Chart area ..creates a drill down or filters data of all charts and raw table in the Active dashboard sheet.
What we need is a Flexible Dashboard Template, and NOT a fixed dashboard tied with a fixed type of dataset.
All our datasets have exactly similar 6 fixed Dimensions. We want a Dashboard template , where we can change data of different Industry with minimal effort using a control sheet.
Data can be large and in some industry can run into a million rows. Further we need to provide a updated dashboard every month.
Any suggestions are welcome. We came up with a web based dashboard, but users refuse to use anything except Excel.
1) For Users - Neatly formatted Corporate Dashboard Template
2) For Users - Ideally with a installable VSTO or VBA Excel Addin Exe Or Macro Code
( I can manage the Installer part only if required - please confirm )
3) Admin Excel Addin or Macro Code
4) All source Codes.
Delivery time is 3 weeks including testing.
More details are given in the attached "RAR" file which contains detailed specs in Word screenshots and questions.
Pls provide answers in the [url removed, login to view] along with your bid.
Thanks & Regards
24 freelancers are bidding on average $2335 for this job
Hi, I have more 10 years experience in MS Office automation, so I'm realy GURU in this. I can help you with this project, so just contact me. Best Regards, Alex
Hi, I am an experienced reports and dashboard developer and currently working directly for a fortune 500 company CEO. Contact me if you are looking for executive quality reports. Regards, Ashish
I am an expert data analyst and have experience in building dashboards with VB and form controls. I was unable to see the attachment and hence unable to respond with a [url removed, login to view]