563 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
|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.|
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:
25 Aytoun Street