How can we help?

Close
icon

Give us a call

Our team of experts are on hand and ready to help.

0161 883 2655
icon

Live chat

Ready to chat data? That's what we're here for

icon

Submit an enquiry

Fill out your details and one of the team will be in touch

Get in touch

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

Graphic

Our blog

Get up to speed on what’s happening in the world of Data…