COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
10 Excel Quick Tips
Part seven of a ten-part series of blogs

Posted by Andrew Gould on 02 December 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Excel Quick Tip #7 - Creating a Chart

You can create a chart in Excel by pressing a single key on the keyboard!

  1. Select the cells you want to provide the data for the chart.
Selecting cells

Here we'll create a chart with two data series - one for each column of numbers we have selected.

  1. Press the F11 key on the keyboard.
Created chart

You can now edit and format the chart in any way you like.

You can see the technique in action in this short video on Wise Owl's YouTube channel.

This blog has 0 threads Add post