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

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.

  • To start to create graph in Excel you need to enter the required data into a spreadsheet. You must remember to give your data in the spreadsheet labels.

  • Now click on the Insert tab on the Excel ribbon and then on have the charts panel that will present you with a selection of different graph  types.

  • Once you have selected a type of graph, click on the select data tab. When the dialogue box opens you can either enter the cell range in the area, or click and drag the required cell area on the spreadsheet.

  • After you have created a basic graph, you can start to alter the design and look of it to what you require. Once a graph is created, it is easy to change from one style of graph to another.

  • If you click on the graph the chart tools group appears on the ribbon. On the design tab you can choose the layout for the chart. You can choose if you want your graph to have a title, the positioning of the axis titles and whether you want to show the graph legend. The design button will also allow you to switch the axis around.

  • The layout tab lets you edit the labels on your graph, including title and axis titles. It will also allow you to display the data labels on the graph, it will give you options to display the data as a percentage if you want.

  • By using the format tab, or right-clicking on the graph you can change the look of the chart, changing the colours of the data area, the plot and background areas and also the colour and size of the font used.

Graphic

Our blog

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