98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Turning quarterly data into graphs to compare | Excel forum
Turning quarterly data into graphs to compare | Excel forum
Resolved · Medium Priority · Version 365
Isabel has attended:
Excel Introduction course
Turning quarterly data into graphs to compare
Hello
I work at a barristers chambers. Each quarter we review how many cases barristers have been offered to work on and accepted and how much they have been paid with other barristers of the same seniority according to gender, ethnicity and disability. There are four seniority brackets. We record times a solicitor has requested a barrister by name and times that barristers have accepted work that comes in to our organisation unnamed and they have been offered it internally. We do this to see if there are any problems with people underrepresented in law getting less work offered to them or getting paid less for comparitive work. We currently look at each quarter in isolation but would like to input our data into a graph (or two graphs one for cases and one for payments) so that we can see trends over long periods of time.
Each quarter I am sent an excel sheet generated by a colleague through our case management system LEX, which has collected the data throughout the quarter on what cases people have been working on and how much they've been paid.
We look at the data in an anonymised form. So for example (these numbers are completely made up) it might be something along the lines of
QC
Male 35 times requested 42 times accepted 13
Female 35 times requested 42 times accepted 13
Total opportunities X average opportunities Y
(repeated for ethnicity, disablility in four different brackets)
I was wondering the best way to turn this into a graph on excel so we can visually see trends?
It would help to have a step by step guide as although I use excel fairly frequently and am able to grasp new steps on it I have never had formal training on how to create graphs
Best wishes,
Isabel
RE: turning quarterly data into graphs to compare
Hello Isabel,
Thank you for your question. Excel charts are very sensitive to how the data is entered and arranged. In order for us to help you in the most effective way, would it be possible to send us an Excel file with some anonymous sample data? The email address is: info@stl-training.co.uk. This data should be laid out the same as your real data, if possible.
We can then decide on the best way forward and take you through the steps.
Kind regards
Marius Barnard
STL
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Line breaks in a cellYou can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. |