google sheets two y axis This is a topic that many people are looking for. khurak.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, khurak.net would like to introduce to you Two Axis Chart – New Google Sheets Chart Editor . Following along are instructions in the video below:
” m going to show you how to make the chart or graph for the summary summary table. It has three columns. The first column shows the number of coins in rocket. When it s launched.
The second column shows the mass of the rocket as it s launched and then the third shows the height that it achieves when it s launched. The challenge here is that we have two different kinds of data. We have mass in grams with values ranging from 20 to 30 ish and we have height in centimeters with values ranging from 150 ish to around 130 ish. The challenge of putting this on one graph is that you ve got kind of two different size values.
And you ve got two different units. And so i m going to show you how you can create a graph that actually shows both of these at once. I m gonna start by highlighting the data area and releasing clicking the chart button. It s gonna do its best to create a chart and this chart is okay so far as it is but we really want to make some adjustments.
We ve got the horizontal axis here that shows the number of coins and that looks good and then we have this scale here that goes from 0 to 200. And it isn t labeled it doesn t really tell us what it is and we have to use this legend to sort of see that the blue items are mass in grams. The red items are height in centimeters for this graph we really would like to have this vertical axis on the left pertain to the mass and have another axis on the right that pertains to the height and maybe has its own scale..
So that s what i m going to show you from here on out. When you create a graph or a chart it creates this chart editor that opens you can close it with this x you can reopen. It by going to the three dot menu and hit edit chart. It s already picked out the correct chart type.
But you can pick out a different chart type. If you need to but for this one you want this column chart and then a lot of the stuff. We re gonna do is on this customize tab the first thing we re gonna customize is called series we re gonna go to series and we re gonna say that for the mass side the blue side that s over on the left. We re gonna leave that on the left and have it be blue.
So we re really not changing that here s the major change. We re gonna say we re gonna say that we want the height side. We ll keep it as read. But we want to move it from the left to the right notice.
What happens over here. Now we have a right side column that has an appropriate scale. So starting from about 28 going to about 30 over on the left and starting from 130 going to 155 over on the right so the next thing..
We want to do is we have numbers here. But we don t really have labels you can kind of use the legend over here to see what the labels represent. But there s a clearer way we can label that and so that s called chart and axis titles. The chart title is already given as mass and height you could change this to something like rocket launches or whatever the assignment requires you to have there s another area that s a subtitle like coins or actually let s call this one summary table and so you can see rocket launches up here.
Summary table appears here and then we have places. Where we can label the horizontal axis. It says number of pilots say number of pilots and then for the vertical axis. This is misleading this really should say left vertical axis because it pertains to the left side here the left vertical axis.
We can call this mass. Grams. And then the right vertical axis. We can say height and then centimeters now we have labels on all three axes and we have a title that makes sense for this the last area you might consider adjusting it only depends on the type of graph that you re doing.
It s not necessary for this one. But i want to show it to you is this area that says vertical axis and right vertical axis when we open up vertical axis again. It s misleading..
This should say left vertical axis you could change things like the font. The colors the sizes of the text that s labeled there. But it may also be important to change the minimum and maximum values right now it starts with a minimum 20 and a maximum of 32. What if we said the minimum was zero and the maximum we leave empty now you can see it goes from zero to 40 and kinds of spread that spreads.
The data out in a different way so that was the left vertical axis. We can do the same thing with the right vertical axis. We can say that we want the minimum to be zero. So now it goes from zero to about 200.
So it really depends on the kind of graph you have it depends on what kinds of data. You have if you have some data that s negative numbers and some data that s positive numbers you might need to say the minimum is you know negative 100 or negative 1000 depending on how big your data is to make it so that the bars actually go down below zero. But we can also put things kind of roughly back the way they were if we don t think that this is the right way to do it. So i think that for this data.
It helps to show the values that are 0 to 40 over here and 0 to 200 on this side. But if you didn t like that you could go back and say for example. The lowest value for mass..
Which was on that left vertical axis was about 20. So you could say maybe the minimum is like 10 and yi closes temporarily this lowest value for height was 133. So we can open up a chart editor. Again and to go to customize and go to write vertical axis and maybe we want that minimum to be around 100.
So this sort of shows it i mean it s still accurate it s the new numbers are still accurate. But it kind of spreads. The data out in a different way it might make the changes look more dramatic or it might make them more evident. If you spread them out in slightly different ways.
So you can change the minimum and maximum values for these columns in order to compress or stretch out the data as you need to but anyway. In any case. You have the chart done at this point. And when you grab the chart you can slide this around on the sheet.
You also have choices like copy the chart this makes a copy like a picture that you can then paste into a doc. If you need to or you can save an image into your google drive that you might ” ..
Thank you for watching all the articles on the topic Two Axis Chart – New Google Sheets Chart Editor . All shares of khurak.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“Create a graph with a left and a right vertical axis in the new (2017) Google Sheets chart editor.”,