Home and Learn: Microsoft Excel Course
For this last chart, we'll compare the viewing figures of BBC1 and ITV. A line chart is better for this type of data. The chart we'll create looks like this:
We're comparing how many hours per week a person watches BBC1 with how many hours they watch ITV. You'll need some data, of course. Start a new spreadsheet and enter the same data as below:
Once you have your spreadsheet data, highlight the cells A3 to H5. Now click Insert from the Ribbon bar in Excel 2007 and 2010. Locate the Charts panel, and click on Other Charts. From the menu, select All Chart Types (In Excel 2013 and 2016, there is no Other Charts option. See below for what you should do):
When you click All Chart Types, you'll get a dialogue box popping up:
From the dialogue box, the left hand side shows all the chart templates. Click on Line. Select the first Line chart, the one highlighted in the image above. Click OK and Excel will insert your chart. It should look like this:
In Excel 2013 and 2016, click the Recommended Charts item instead of Other Charts:
You'll then see a dialogue box appear. Click on All Charts:
Expand Line from the list on the left to see all the available line charts (2016 users will have more charts on the list). Select the first one. Your charts will then look like this:
For all Excel users, the chart looks a bit plain, at the moment. You can change the colour of the lines for BBC and ITV. Locate the Chart Styles panel on the Design menu:
Click the down arrow on the right of the Chart Styles panel to reveal the available styles:
We've gone for the first one, top left. When you select a style, your chart will change:
The lines are more distinct now. The dates at the bottom don't look too impressive, though! In the next part, you'll see how to format the dates on the bottom Axis.
Format Data Axis in Excel 2007 to 2016 -->
<--Back to the Excel Contents Page
Email us: enquiry at homeandlearn.co.uk