You are currently viewing How to make a chart on Google docs

How to make a chart on Google docs

Google charts are graphical charts that are created from user-supplied information. Google charts are a simple and easy construct. Since they are automatically drawn, they are less prone to errors that may occur during hand drawing. They are more presentable because they are neat and more visible as compared to hand-drawn charts. Saving time is the main advantage of using this software to make charts as it takes a short time to convert the inputted data to the desired chart. A Google sheet also plays a vital role in reducing paperwork and preventing information loss that mainly occurs when papers are used.

However, regardless of its numerous advantages, it has a significant disadvantage. Many of those using Google docs to create chart may experience a significant challenge in constructing a chart due to the complicated procedure involved. Therefore a new user may rely on a guidance manual to use and enjoy the benefits associated with Google sheets in making of sheets.

The following are the steps to follow when making a chart using Google Docs software.

Step 1

This is vital and the initial step when using Google docs to make charts.

  • Open Google sheet software in any of your suitable web browsers.

The image below shows an empty spreadsheet that is ready to input data.


It contains tabs on the uppermost part of the screen, columns and rows, which have numerous empty cells where you will input the  data required in making the chart. The rows are named using numbers (1, 2, 3 …), while the columns are alphabetically named (a, b …

Step 2

After opening the Google sheet software,the next step is to;

  • Create a spreadsheet to input the data you’d like to convert to a chart.
  • Click “File,”  on the left side of the tabs on the menu. Then click “new,” which appears after clicking the “File” tabs.
  • After clicking the new tab, different types of sheets are displayed.
  • Click on the “spreadsheet” and wait for the empty spreadsheet page to display how you will input the data.

Now the spreadsheet is ready to input data, and therefore, you can proceed to the next step.

Step 3

  • Input  the values and other necessary information on the spreadsheet empty cells.
  • Each row in the spreadsheet has different columns. The uppermost rows and the leftmost column in the spreadsheet contain the labels of the chart.

To illustrate this, lets draw a chart showing the profit of a particular company recorded in three consecutive months, as shown below.


When inputting data that should be converted to a chart, you should be careful to avoid errors associated with omission and swapping of values. The software will not detect the errors made preferably. It will output the data inputted hence resulting in an incorrect chart. Each data should match with its partner in the next column.

Step 4

After inputting all the information, the next step is simple t involves;

  • Highlight  all the inputted data.  Be careful  when highlighting, only the highlighted information will appear on the chart.
  • Omitting some data while highlighting may result in incorrect output. Therefore all the inputted information should be highlighted before clicking the “chart” setting.

This is shown using the above example.

Step 5

This step involves converting the highlighted data to a suitable chart.

  • After all the information is highlighted, click the “insert” tab on the menu. The number of the highlighted rows and columns along other settings is displayed by clicking the Insert tab.
  • The number of rows and columns displayed can help you to confirm all the data present.
  • The basic primary setting is “chart,” and it appears immediately the number of rows and columns.
  • Lastly,  click the “chart” part and wait for the data to convert to a chart automatically.

Step 6

  • After clicking the “chart” setting, the data will automatically be converted to a chart, and it will automatically suggest the type of chart that fits your data best.
  • The recommended chart is displayed on the same page as the inputted data. The location and the size of the chart can be changed and be adjusted, respectively. Before changes are made on the chart, the uppermost rows, i.e., profit (sh.) vs. month, appear as the chart’s title and the labels of the chart’s axis.

However, you can choose the format of the Google chart that you want. The type of chart chosen will depend on the type of data one is working with. Changing the format of the chart is facilitated by the ‘chart editor,’ which is launched on the rightmost side of the sheet after converting data to chart. The editor has numerous types of charts.

Step 7

This step mainly involves changing the type of chart that fits your data. This is largely done on the chart editor.

  • Click the “chart type” setting and choose the type of chart that fits best the format of the data.

Below is an image of how to change the format of a chart.

This setting helps the user to change the format of the setting if you are not satisfied with the recommendation chart.

Step 8

This is the last and optional step that is aimed at customizing the Google chart to look exactly the way the you  want.

  • Through this setting, you  are able to access different styles and other settings that make the chart more presentable and easy to understand.
  • The customizing setting is located in the chart editor, which is on the right side after the setup setting. This setting helps to update the title, axis, and presentation style by changing the color and styles of the chart.

Following the above steps makes it easier for new Google sheet users to create and edit their own charts without experiencing any challenge.

Leave a Reply