How to Create a Chart in Excel

Creating a chart in Excel allows you to visualise your data and make more sense of it. Here’s how to create a chart.

  1. Highlight the required data
  2. Select ‘Insert’ to choose either a chosen chart, or a chart type recommended by Excel
  3. Insert the chart
  4. Add titles, axis labels and colours for professionalism

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