Click the "Insert" tab at the top of the screen, then click on the pie chart icon, which looks like a pie chart. If you wish to display multiple data sets on one chart, consider a different chart ...

Using a scatter chart automatically plots the ranges against their frequencies, but using a column graph creates a familiar histogram type chart. Open Microsoft Excel and list your data in column A.

For instance, you can create a chart that displays two unique sets of data. Use Excel's chart wizard to make a combo chart that combines two chart types, each with its own data set.

Finally, Format Your Chart. Once you've selected the right type of chart for your data, make sure you don't do your data a disservice by forgetting some basic design tips.Kill the grid lines ...

Pie charts are the Aquaman of data visualization. Aquaman is really only good at one thing. Even so, other DC superheroes can often do Aquaman's job better than Aquaman.

What really sets R apart is ggplot2. This visualisation package, which was also developed by Mr Wickham, allows you to create different charts and visualisations with just a few lines of code.

Off the Charts is a weekly, subscriber-only guide to The Economist’s award-winning data journalism and the ideas, processes and tools that go into creating it. Sign up for Off the Charts .