How to visualise Data by Creating a chart in Excel

Creating a chart in Excel allows you to visualise your data and make more sense of it. Excel offers many different forms of charts from simple bar charts to surface charts, there is always one to display your data.

Below is a set of data which shows 5 people rating a food product.

Excel chart

To put this data into a chart you would highlight it. Excel chart

Then select the insert tab. You can then either select what chart you want to use or let Excel recommend a chart which will display your data.

Excel chart

You can then go through the charts and select which one you want.

Excel chart
Excel chart

 

Once the chart has been inserted, you can add titles, axis labels and format it.

Excel chart

You can change the chart type under the design tab.Excel chart

For this data a radar diagram is the best way of displaying it.Excel chart