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:

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

• 
  
  From the menu bar, click Edit


• 
  
  From the drop down menu, select Copy


• 
  
  Highlight P1 to P10 of the ITV Row

• 
  
  From the menu bar, Click Edit again


• 
  
  From the drop down menu, click Paste Special


• 
  
  The following dialogue box pops up

• 
  
  
  

  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