I need to present 8 graphs for my company
- or -
Post a project like this1594
£105(approx. $131)
- Posted:
- Proposals: 14
- Remote
- #2630058
- Awarded
Excel expert, business analyst, writer, skilled user of Word & Powerpoint, CV experienced
Chelmsford
Graphic Designer | Illustrator | Animator | Video Editor | Infographics |Brochures |Videos|Presentations|Data Visualization |e-Books designing
Rawalpindi
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
31236812082704864955208967526492156754261258526727692717786329692833112483378403
Description
Experience Level: Expert
I have a small manufacturing business and the bigger we grow I want to report weekly to the team on a few KPIs (8 graphs in total). We're great at woodwork, but not at Excel so I'm hoping you can help as long as the price is sensible. I've made suggestions on the type of chart I think i required but open to suggestions, you're obviously more experienced!
With each of these I'd like to:
Have an 'input' sheet where we can manually type that months / weeks data
Be able to easily select a date range which will show in the graph (last 3 months or last 12 months for example)
Have a pre-linked powerpoint presentation which has one graph per page that I can present to the team
What I'd like to report on
Production:
Machine 1 - % running time per week vs. Machine 2 - % running time per week
(line graph with points)
Machine 1 - amount of parts per week vs. Machine 2 - amount of parts per week
(line graph with points)
Remakes per week - our fault vs. remakes per week unforeseeable
(column chart? Will hopefully contain quite a few zeros, not sure if there is a style which would benefit this)
Total machine breakdown / service time
(line graph with points)
Quality:
Complaints errors per week
(column chart?)
Sales:
New Leads per month vs. Jobs confirmed per month
(mixed column and line graph?)
Value invoiced per month vs. target (£k)
(column chart? Or mixed like above?)
With the above considered can you let me know if this is the correct hourlie, and which optional extras I need to add.
Cheers
Kenny
With each of these I'd like to:
Have an 'input' sheet where we can manually type that months / weeks data
Be able to easily select a date range which will show in the graph (last 3 months or last 12 months for example)
Have a pre-linked powerpoint presentation which has one graph per page that I can present to the team
What I'd like to report on
Production:
Machine 1 - % running time per week vs. Machine 2 - % running time per week
(line graph with points)
Machine 1 - amount of parts per week vs. Machine 2 - amount of parts per week
(line graph with points)
Remakes per week - our fault vs. remakes per week unforeseeable
(column chart? Will hopefully contain quite a few zeros, not sure if there is a style which would benefit this)
Total machine breakdown / service time
(line graph with points)
Quality:
Complaints errors per week
(column chart?)
Sales:
New Leads per month vs. Jobs confirmed per month
(mixed column and line graph?)
Value invoiced per month vs. target (£k)
(column chart? Or mixed like above?)
With the above considered can you let me know if this is the correct hourlie, and which optional extras I need to add.
Cheers
Kenny
Kenny M.
100% (25)Projects Completed
38
Freelancers worked with
14
Projects awarded
10%
Last project
19 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Kenny,
It would really help if you can share a sample of the dataset. It will help in understanding what's possible and what's not.
870885
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