Stay at Home and Learn

Microsoft Excel Tutorials

Computer Tutorials List

Excel 2007

A More Complex Excel Bar Chart

We gave ourselves some space in our spreadsheet for a reason. Where the pie chart used to be, we're going to arrange our TV data in a different order.

Add the following data to your spreadsheet:

Add this data to your spreadsheet

That might be a bit small to see, but the numbers are just the viewing figures for ITV and BBC 1. The P1, P2, etc, means Position 1, Position 2, and so on. The highest viewing figure is under P1 and the lowest under P10

A quick way to copy all the numbers over, instead of having to type them out all over again, is to do this:

Highlight the ITV numbers

Highlight the ITV data

From the menu bar, click Edit
From the drop down menu, select Copy
Highlight P1 to P10 of the ITV Row

Highlight the row

From the menu bar, Click Edit again
From the drop down menu, click Paste Special
The following dialogue box pops up

Paste Special dialogue box

Put a tick in the box at the bottom, next to "Transpose"
Click the OK button
Your numbers will all be pasted over to the ITV Row
Do the same for the BBC1 numbers

When you have added the new data to your spreadsheet, you can move on to Project Three. Because that's the end of the excel charts section. The next section is all about formulas.

<-- Back One Page Move on to Project Three-->

<--Back to the Excel Contents Page