Excel Dashboard with Excel VBA Addin - Top Menu Left Pane
This project received 24 bids from talented freelancers with an average bid price of $2335 USD.Get free quotes for a project like this
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
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online