Creating a chart in Excel allows you to visualise your data and make more sense of it. Here’s how to create a chart.
- Highlight the required data
- Select ‘Insert’ to choose either a chosen chart, or a chart type recommended by Excel
- Insert the chart
- 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.
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.
You can then go through the charts and select which one you want.
Once the chart has been inserted, you can add titles, axis labels and format it.