Using a spreadsheet to make a chart or a graph is really handy and it’s not too difficult either and we’ll show you how. Here’s how to make a graph in Excel or Google Drive. See also: How to use Excel
Graphs and charts are useful for all kinds of things. Visually looking at data is much easier for most people compared to trying to decipher many rows and columns of numbers. Although doing something like this might be a bit daunting with software such as Excel but that’s why we’re here to help.
See also: How to make PivotTables in Excel.
How to make a graph in Excel or Google Drive
Step one
First you’ll need to put your data into a new spreadsheet so open up a new on and get typing. This will look different depending on what you’re wanting to show.
Step Two
Select all the data you want to show in the graph - Make sure you include the titles so you know what’s what on the graph.
Step Three
Click on Insert then on the chart or graph of your choice. You can choose between column, line, pie, bar, area, scatter or other. (In Google Drive, click Insert then Chart then choose your style).
Step Four
Now use the chart design and layout tools to make any tweaks you need such as switching rows and columns, title, legends and labels.