Build an Excel business dashboard using traffic lights to summarise information
- or -
Post a project like this2994
$$$
- Posted:
- Proposals: 5
- Remote
- #1026007
- Awarded
Description
Experience Level: Expert
Description of excel work: I'd like an Excel dashboard to enter business data into. It will then summarise the information using the traffic lights system.
I would like to enter 12 months of data, in different blocks - i.e. turnover; cash flow; appointments.
Start with 10 blocks but make it easy for me to copy a traffic light to add new blocks in the future.
For each block, I must be able to enter the parameters to set the different colours of the traffic lights.
There will be a drop down to pick the month.
I can supply sample data.
It must be visually beautiful
It needs to be compatible with Excel for Mac 2011. Ideally, we would like to import it into Google Sheets.
Extra notes:
I would like to enter 12 months of data, in different blocks - i.e. turnover; cash flow; appointments.
Start with 10 blocks but make it easy for me to copy a traffic light to add new blocks in the future.
For each block, I must be able to enter the parameters to set the different colours of the traffic lights.
There will be a drop down to pick the month.
I can supply sample data.
It must be visually beautiful
It needs to be compatible with Excel for Mac 2011. Ideally, we would like to import it into Google Sheets.
Extra notes:
Paul G.
100% (12)Projects Completed
14
Freelancers worked with
15
Projects awarded
65%
Last project
2 Mar 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies