Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Another OOH moment in Excel - a quick way to create charts |
---|
The previous blog listing great OOH moments in Excel omitted one of the biggest - the absolute quickest way to create a chart. |
In this blog
Jenny was miffed that I had missed this out from my 5 favourite ooh moments in Excel blog a couple of months ago, so I thought I'd make good my error.
So let's suppose you want to create a chart comparing the population of different parts of the UK:
A good first step is to select the data you want to show in your chart.
Now just press one of the following keys:
Key | What it does |
---|---|
F11 | Creates a separate page chart |
Alt + F1 | Creates an embedded chart |
That's it! Obviously you'll now have to customise your chart ...
While on the subject, you can choose what data to select by judicious use of the Ctrl key. For example, this selection would compare the populations of the English regions only:
It takes a bit of getting used to selecting data like this - the crucial thing is to avoid including any cell or cells twice, and to make sure that the data you select forms a rectangle.
Here's what this would show when you press F11:
The chart only shows the data you selected.
The reason I got a column chart for the above example is because that's the default default chart type (ie the default chart type that you get if you don't set any other). However, it's easy enough to change this:
Like doughnuts? Right-click on the particular subtype you like, and set this to be your new default.
And with that, my penance is complete!
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.