HOW TO CREATE COMBO CHART IN GOOGLE SHEETS

INTRODUCTION

CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in the form of different charts and graphs etc.

GOOGLE SHEETS gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.

In this article we are going to discuss COMBO CHARTS which is a combination of two charts on the same axes.

COMBO CHART IS THE TYPE OF CHART WHICH IS A COMBINATION OF MORE THAN ONE TYPE OF CHARTS IN GOOGLE SHEETS

For example, if we have a combination of line chart and column chart, we can get the following information at the same time.

In a line chart , slope tells the rate of increment or decrement whereas column chart simply marks the values.

In this article, we would learn to use a combo chart in google sheets.

WHAT ARE COMBO CHARTS IN GOOGLE SHEETS

THE COMBO CHARTS [ COMBINED CHARTS] IS A COMBINATION OF TWO OR MORE CHARTS IN GOOGLE SHEETS. WE CAN COMBINE MANY CHARTS TOGETHER SUCH AS LINE, COLUMN , AREA AND SO ON.


WHERE IS THE OPTION FOR COMBO CHARTS IN GOOGLE SHEETS

The COMBO chart can be easily inserted by the chart button on the toolbar itself.

The button location is shown in the picture below.

TOOLBAR BUTTON LOCATION FOR CHARTS INSERTION

  • Click the CHARTS BUTTON which will open the Chart Editor.
  • In the Charts Editor, Select COMBO CHART from the CHART TYPE DROP DOWN LIST as shown in the picture below.
TOOLBAR BUTTON LOCATION FOR COMBO CHARTS

MENU OPTION TO INSERT A COMBO CHART: We can insert a chart using the Menu also as chart option is available in the menu too.

  • Go to INSERT MENU > CHART.
  • After clicking the CHART , CHART option will appear.
  • Choose COMBO CHART from the CHART TYPE DROP DOWN. Charts Editor is exactly same as shown in the picture above. [ TOOLBAR BUTTON FOR CHARTS INSERTION ]

The location is shown below in the picture.

MENU OPTION LOCATION FOR INSERTING COMBO CHART

STEPS TO INSERT A COMBO CHART IN GOOGLE SHEETS

EXAMPLE DETAILS

We can demonstrate the creation of chart using an example.

We’ll discuss an example which shows the projected sales vs actual sales vs difference between the projected sales and actual sales.  

YEARPROJECTED SALESACTUAL SALESDIFFERENCE
201112102
201215141
20131415-1
201420191
201525223
201640382

The procedure to insert a COMBO chart are as follows:

STEPS TO INSERT A COMBO CHART IN GOOGLE SHEETS :

  • The first requirement of any chart is data .  So create a table containing the data.  [ We have already created in the form of table above]
  • Refer to our data above, we have  SALES DATA FOR 6 YEARS.
  • Select the complete table including the HEADER NAMES.
  • Go to TOOLBAR > CHARTS .
  • CHART EDITOR will open on the right side.
  • Click CHART TYPE and choose COMBO CHART from the drop down list.
  • The chart will be created as shown in the picture below.

The process is depicted in the picture below.  

SELECT THE DATA AND CHOOSE COMBO CHART

We can see that the three series are shown with the help of a column chart and two line charts in the same space.

After a few tweaks, here is our final combo chart.

FINAL COMBO CHART

HOW TO CHOOSE THE INDIVIDUAL CHART TYPES IN COMBO CHART IN GOOGLE SHEETS

EXAMPLE DETAILS

A need may arise when we want to choose the individual chart type for a particular series.

In our example, we have three series. Let us learn to find out the way to choose the individual chart type.

Currently , we have the following charts in our Combo chart.

Actual Sales and Difference are as a Line Chart and Projected Sales is shown as a column chart.

Let us change the Actual Sales to Column chart .

The procedure to insert a COMBO chart are as follows:h

STEPS TO CHANGE INDIVIDUAL CHART TYPE IN COMBO CHART IN GOOGLE SHEETS :

 We have already created a combo chart in the previous section.Let us try to change the chart type of actual sales from LINE CHART to COLUMN CHART in the combo chart we created. 

  • Double Click the chart to open the CHART EDITOR on the Right portion of screen.
  • In the CHART EDITOR, choose CUSTOMIZE TAB.
  • Go to SERIES options and click it.
  • The process is depicted in the picture below.
SELECT THE CHART AND GO TO SERIES EDITING OPTIONS UNDER CUSTOMIZE TAB
  • In the SERIES OPTIONS click the SERIES DROP DOWN as shown here and choose ACTUAL SALES.
  •  Now click the TYPE DROPDOWN and choose COLUMNS to choose the COLUMN CHART TYPE.
  • The settings are shown in the picture below.
SELECT THE DATA AND CHOOSE COMBO CHART

As we make the selections, the chart type of the series ACTUAL SALES will change immediately.

The final chart is shown below.

FINAL CHART AFTER CHANGING THE INDIVIDUAL CHART TYPE

This way, we can change the chart type of any given series and can change more options too.

NOTE:

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN GOOGLE SHEETS ].

In this article, we learnt about the Combo Charts, how to create them, how to change the individual charts with the help of examples.