Making a graph in a Excel spreadsheet is fairly simple and can be used to show data in a more…Read more
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. (fig 1)
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. (fig 2)
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.