Fantastic Google Chart Multiple Y Axis

Patrik_gfeller Patrik Gfeller August 6 2017 803pm 1.

Google chart multiple y axis. Next to Apply to choose the data series you want to appear on the right axis. You can add a second Y-axis to a line area or column chart. You can control the color with annotationsdomainstemcolor the stem length with annotationsdomainstemlength and the style with annotationsdomainstyle.

In the Chart Data view select the data rows and columns to include in the secondary Y-Axis. LineChart with two y-axes. 1 Is it possible to create a dual Y-axis spreadsheet chart using the in-house charting features of google spreadsheet.

I utilized another service HighCharts and was able to accomplish this quite easily See example 2 below. Following the below steps you will find that making two y axes in chart is very easy. Chart showing use of multiple y-axes where each series has a separate axis.

For charts that support annotations the annotationsdomain object lets you override Google Charts choice for annotations provided for a domain the major axis of the chart such as the X axis on a typical line chart. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. Split Dual displays the secondary Y-Axis below the chart.

For both examples the source grid has Accounts in the rows for. Multiple axes allows data in different ranges to be visualized together. When a Combination Chart Type is used the Dual Y property is Split Dual OnOff.

A recent update to Google Spreadsheets has added a new feature for former Excel users who are looking to get additional functionality. Under Axis choose Right axis. Double-click the chart you want to change.