Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
24
Project Description

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….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.


Deliverables:

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

Nikhi l

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online