PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
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 LINE CHART AND COLUMN CHART IN GOOGLE SHEETS
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.
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.
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
YEAR | PROJECTED SALES | ACTUAL SALES | DIFFERENCE |
2011 | 12 | 10 | 2 |
2012 | 15 | 14 | 1 |
2013 | 14 | 15 | -1 |
2014 | 20 | 19 | 1 |
2015 | 25 | 22 | 3 |
2016 | 40 | 38 | 2 |
The procedure to insert a COMBO chart are as follows:
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:
As we make the selections, the chart type of the series ACTUAL SALES will change immediately.
The final chart is shown below.
This way, we can change the chart type of any given series and can change more options too.
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.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE