Creating charts and graphs with google spreadsheets
- Create a basic chart/graph: add data
- select chart type
- add labels
- customize your chart
- Insert chart into Google docs
Google spreadsheets have several great options for manipulating data and creating charts and graphs for reports. It has several excellent features to add and manipulate data which are great for creating attractive presentations. Several times presentations require working with tons of data and you have to present it in a chart or graphical format. Moreover, you would need to make it attractive to engage the audience’s attention. All of this becomes easier with the features included in google spreadsheets and you cannot just make excellent charts and graphs, but also integrate them easily into your documents through the google docs. First let’s try creating a simple graph using a few rows and columns of data.
Creating a basic graph/chart using google spreadsheets : Add data for the chart
To create a graph add data with headers. Go to Insert tab and click on chart. This will create a column chart for you (default option). The chart editor will show on the right. If it does not, just right click on the chart area and select chart style. If you want a different chart than the existing one, you can select a different chart type from the editor.
Select chart type: Go to the chart editor.
Apart from the column chart, you can select bar chart, stacked bar chart, area chart, pie chart etc. There are several options and you can select any depending upon your need. The editor has two parts and you will find these features in the setup part.