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.
This is vital and the initial step when using Google docs to make charts. Firstly, open Google sheet software in any of your suitable web browsers. The opened Google sheet contains tabs on the uppermost part of the screen and columns and rows, which have numerous empty cells where the data required in making the chart are inputted. The rows are named using numbers (1, 2, 3 …), while the columns are alphabetically named (a, b …).
The image below shows an empty spreadsheet that is ready to be inputted data.
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,” which is on the left side of the tabs on the menu. Then click “new,” which appears after clicking the “File” tabs. On 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 be inputted the data, and therefore, you can proceed to the next step.
This step majorly involves inputting 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. When inputting data that are to be converted to a chart, carefulness should be observed 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.
To illustrate this, let draw a chart showing the profit of a particular company recorded in three consecutive months, as shown below.
After inputting all the information, the next step is simple: it involves highlighting all the inputted data. Carefulness should also be observed when highlighting, as 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.
The next 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 the user confirm all the data are present. Here the basic primary setting is “chart,” and it appears immediately the number of rows and columns. Lastly, on this step, click the “chart” part and wait for the data to convert to a chart automatically.
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.
This step mainly involves changing the type of chart that fits your data. This is largely done on the chart editor. The user clicks the “chart type” setting and chooses the type of chart that fits best the format of the data. This setting helps the user to change the format of the setting if he or she is not satisfied with the recommendation chart.
Below is an image of how to change the format of a chart.
This is the last and optional step that is aimed at customizing the Google chart to look exactly the way the user wants. Through this setting, the user is 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.