Create a 2D Line Chart in Excel

Create a 2D Line Chart in Excel

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 Excel Ribbon bar. Locate the Charts panel, and click on Other Charts. From the menu, select All Chart Types (In Excel 2013, there is no Other Charts option. See below for what you should do):

In Excel 2013, click the Recommended Charts item instead of Other Charts:

When you click All Chart Types, you'll get a dialogue box popping up (Excel 2013 users shoudl click the All Charts tab on their dialogue box):

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:

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.

Posted in: Microsoft Excel,Microsoft Excel 3 (Excel 2007/2010 Charts),Tips,Trick,Tutorial,Tutorial Excel 3