These types of charts let you display to different types of values eg: quantity and percentage. The percentage figures will appear on the secondary axis as a different chart type. Click 'Recommended Charts' to have one created for you.

It was lost but now it is found! We can't do much without our Navigation pane to find our files, so when it's missing - life is difficult. What's worse is that it isn't that intuitive to find it, but like anything - it's easy when you know how!

A handy little tip from the Paste options in Excel Copy then Paste and select the Transpose option. It doesn't work if you Cut - only Copy and not next door - select a cell underneath or on a new sheet.