
I need a weekly dashboard created in excel with visual graphs
- or -
Post a project like this278
£85(approx. $113)
- Posted:
- Proposals: 23
- Remote
- #4304088
- Awarded
Excel | Google Sheets | Dashboards | Google Apps Script | VBA Macro | Automation

⭐UK-Accountant | Excel Expert | Bookkeeper | Financial Analyst |Financial Modeling & Forecasting Expert |⭐

13940151178615211834146118443495365050113016301946714118258481148810150666118651671319286





Description
Experience Level: Expert
I need someone who specialises in Excel and speaks English.
We currently have a weekly dashboard in excel showing the following:
- Value of enquiries added year to date, against target
- Total pipeline velocity against target
- Sales month to date against target
- Sales year to date against target
- Revenue year to date against target
- Revenue year to date against target
I have attached a file below of how we show this currently, but i want to make it more visual.
So, i would like
- Value of enquiries year to date: shown in an accumulating line graph against an accumulating target line
- Total pipeline velocity: same as above, but we do currently have this already so this is something i can add on from another sheet. Please leave.
- Sales month to date- as a dial (example attached)
- Sales year to date- as a temperature gage/thermometer style chart.
- Revenue month to date- same as the sales month to date one. A dial.
- Revenue year to date- same as sales year to date- as a thermometer.
Trust this makes sense- if not, happy to discuss on a Teams call.
We currently have a weekly dashboard in excel showing the following:
- Value of enquiries added year to date, against target
- Total pipeline velocity against target
- Sales month to date against target
- Sales year to date against target
- Revenue year to date against target
- Revenue year to date against target
I have attached a file below of how we show this currently, but i want to make it more visual.
So, i would like
- Value of enquiries year to date: shown in an accumulating line graph against an accumulating target line
- Total pipeline velocity: same as above, but we do currently have this already so this is something i can add on from another sheet. Please leave.
- Sales month to date- as a dial (example attached)
- Sales year to date- as a temperature gage/thermometer style chart.
- Revenue month to date- same as the sales month to date one. A dial.
- Revenue year to date- same as sales year to date- as a thermometer.
Trust this makes sense- if not, happy to discuss on a Teams call.

Cristal D.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
23 Dec 2024
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