Google Sheets is one of the most popular cloud-based spreadsheet apps from Google. It is an important free alternative to classical spreadsheets apps such as Microsoft Excel. In this article, I will show step by step how can you use “Pie charts”, and “Horizontal Bar charts” in Google Sheets to represent a simple set of data of monthly expenses. Although the thought of using fancy charts to represent data in Google Sheets might sound intimidating, it can be performed in a few easy steps as given below.
Inserting a Pie Chart
Step 1: First launch “Google Sheets” and start with a blank page. Step 3: Select the data in the spreadsheet that you want to represent in the chart. For example in my case, the data range is E7 to E12.
Step 5: You will notice that by default a “Pie” chart has been inserted for your selected data showing the contribution of each individual expense category in percentages to the overall total expenditure.
Inserting a Horizontal Bar Chart
By default, Google Sheets supports the direct insertion of the “Pie Chart” only. If you need another type of chart such as the “Horizontal Bar Chart” then you will have to first insert a “Pie Chart” and then convert it to a “Horizontal Bar Chart”. To do so just follow the following steps. Step 7: If you want to change the look and feel of the inserted chart. Then double-click on the chart and select the “Customize” tab and do changes accordingly.
Step 1: First insert a “Pie Chart” by following Steps 1 to 6 as in the previous section. Step 3: To convert this chart into the “Horizontal Bar Chart” click on the “Setup” tab.
Step 5: Google Sheets will give you some suggestions regarding the different types of available charts. You can scroll down and check other types of charts as well. Step 7: You will notice that your earlier inserted “Pie Chart” has now been converted into a “Horizontal Bar Chart”.
Step 8: If you want to change the look and feel of the inserted chart. Then you can do that from the “Customize” tab.
Wrapping up
Charts are integral for presenting data graphically. Google Sheets provides an easy and intuitive way of including charts in your worksheet. One noteworthy thing is that Google Sheet does not allow other than the “Pie Chart” to be inserted directly. Therefore, if other types of charts are needed then the user must first insert a “Pie Chart” and then edit it to change it into the desired chart. Several aspects of the inserted chart can be changed from the “Customized” tab in the “Chart Editor” window.
