How can we help?


Give us a call

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

0161 883 2655

Live chat

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


Submit an enquiry

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

Get in touch

How to Make a Graph in Excel

Making a graph in a Excel spreadsheet is fairly simple and can be used to show data in a more visual format. There are different types of graphs available including, column, bar, line and pie charts. The type of graph that you use in a spreadsheet depends on the type of data results you need to show, as some graphs represent different results better than others.

Whatever style of graph you use, setting them up is all the same, in fact you can change you can switch between one style of chart to another and then just alter the layout of the graph to make it easier to read.

How to Make a Graph in Excel to Visualise Data

Creating eye-catching, informative visual representations of data is very simple yet so many excel users do not know how to create such graphs and charts. This article will go through step by step on how to make a graph in excel and some simple formatting options.

The first stage is to create your series of data. A very simple example of a data series can be seen below, where each person in question has an allocated score.

How to make a graph in excel

How to make a graph in excel

To create a basic chart, highlight the cells required and select the ‘Insert’ tab in the main toolbar. In this toolbar the option to select a chart type is available, as indicated below. Once the graph type has been selected Excel automatically processes the data into a visual representation.

how to make a graph in excel

How to make a graph in excel

Once you are able to make a graph in excel, the next stage is to format the graph to meet your specific requirements. To begin formatting the chart, click on the  ‘Design’ tool option in the main menu and then select the ‘Add Chart Element’ option as shown below. Once this option is selected the range of modifications to the chart are numerous, including adding axis titles, error bars, legends etc.

how to make a graph in excel


The best graphs and charts give a clear indication of the data they represent but in a captivating, aesthetically pleasing manner.