If you choose the vertical axis, follow these steps;
Two vertical axis google sheets. Khurak.net is a channel providing useful information about learning, life, digital marketing. For a discrete axis, set the data column. In this case, that’s a2:d14.
In the first example below, i will use only one/single keyword each,. At the top of the section is a dropdown menu to select which chart title you want to edit. At this point, a chart editor will appear along with an.
Next, find the insert tab on the top part of the document and click chart. Create a graph with a left and a right vertical axis in the new (2017) google sheets chart editor. Change axis to right axis.
Adding a secondary data series. In the following example, the category axis contains dates. The source data is in cell range b1:c (not in b1:d),.
Select secondary axis from plot series on options. Now you can go back. In my report for horizontal axis i have values:
Change apply series to whichever data series you want to move to the second axis. In line, area, bar, column and candlestick charts (and combo charts containing only such series), you can control the type of the major axis: Click on format selection in current section to open format data series dialog.