How to make a graph or chart in Excel or Google Drive

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.

Author: Chris Martin, Reviews Editor, Tech Advisor

Chris got his break as a reporter at infamous site The Inquirer and has been at Tech Advisor for more than 12 years. With a BA degree in Music Technology, audio is his specialism, but over the years he has reviewed all kinds of gadgets, from smartwatches to mesh Wi-Fi to coffee machines.

Recent stories by Chris Martin: