馃攳
Excel - how to plot 2 vertical y-axes on a line graph - YouTube
Channel: unknown
[0]
Welcome to a quick lab skills video where in Excel we're ...
[5]
going to learn how to plot a line graph with 2 vertical y-axes
[11]
As you can see here I have got some example data for a ...
[15]
lactate test. In which I have got lactate ...
[18]
data and heart rate data for rest and 6 stages of exercise.
[22]
I am going to show you in this tutorial how to plot the data ...
[26]
with 2 vertical y-axes.
[29]
If you can look over here, I have got two examples of ...
[32]
graphs that you might see. On the left hand side,
[35]
this is how it would automatically plot:
[37]
where both the lactate and heart rate data are on one ...
[40]
axes. As you can see it's not very ...
[43]
clear because the lactate values are so small in ...
[46]
comparison to the heart rate values the lactate looks like ...
[50]
it's almost one steady line, which it's not.
[53]
So this is how we wouldn't want to see lactate and heart ...
[57]
rate results on one graph.
[62]
On the right hand side you can see here I have one axis ...
[63]
on the left for blood lactate and
[65]
one axis on the right for heart rate.
[68]
And now you can see how clearly you can see the actual ...
[72]
line and the trend of the lactate data and also the ...
[76]
heart rate data.
[78]
I'm going to show you how to do that today.
[81]
I'm going to come back to this original sheet where we have the data.
[85]
The way that I would do this is I'm going to click and ...
[88]
highlight all of the data. All I did here was pressed on ...
[91]
the mouse key, held it down and released it ...
[94]
on the last one. Now it's highlighted I'm just ...
[96]
going to plot it.
[98]
There will be a few different ways of doing this.
[101]
However the way I do this is to hit insert
[104]
and then come over and choose the graph (or chart) ...
[107]
which I'm interested in. For lactate and heart rate I ...
[110]
would commonly recommend a line chart.
[113]
It is up to you whether you have it without or with ...
[116]
markers, however for it to be easily ...
[119]
visualised I am going to use it with markers.
[124]
As you can see, by default it's going to do it ...
[126]
with a single axis, which as we've identified is ...
[129]
not what we'd like to see. I like having the lactate,
[132]
as that's the primary data that we're interested in,
[136]
on the left-hand side. Then I would like the ...
[138]
secondary data on the right-hand side,
[141]
which is the heart rate.
[143]
The way that we do that is, I'm going to simply click on ...
[146]
the heart rate line, okay.
[147]
You will see it's highlighted it.
[150]
Then right click. So again,
[151]
click specifically on the heart rate line
[155]
and right click.
[157]
Then here, if you 'Format Data Series',
[159]
it's going to bring up on the right hand side a few different options.
[163]
You can see 'Primary Axis' versus 'Secondary Axis'.
[167]
I'm going to click 'Secondary Axis'.
[169]
You can see it's automatically changed it for us and already ...
[173]
you can see how it's much clearer for us to view.
[176]
I don't think I really want to make anymore changes,
[178]
so I'm just going to close this down.
[180]
If you wanted you could change the colours and all ...
[182]
sorts of things like that.
[184]
Okay, so that is simply how you ...
[186]
would plot data on two separate y-axes.
[192]
As a standard I would obviously recommend that ...
[194]
you change the titles.
[197]
Okay, to change the title I am ...
[199]
simply going to click on here.
[202]
I have already prepared one, I am going to copy it in.
[205]
It's rather large so I'm going to reduce the font quickly.
[209]
This is something you could spend a lot more time doing.
[216]
Next I am going to add the primary and secondary ...
[219]
vertical axes titles. Again,
[221]
there are different ways of doing this but the way that I ...
[225]
find quite quick and easy to do is this.
[227]
If you notice that when I click on the actual graph/chart,
[231]
it gives these three different options here.
[234]
I'm going to click the add
[236]
and you can see, it's given us all the different ...
[240]
options down here and it's an 'Axis Title'.
[244]
If I just click this box here, what it's going to try and do ...
[249]
is give the axis title at the bottom as well as the vertical ...
[254]
axes. I am quite happy with it ...
[257]
saying 'Rest, Stage 1,
[259]
Stage 2, etc'
[260]
so I don't want the horizontal axis to be in there.
[264]
So if I click on this arrow at the side it gives me further options.
[270]
I just want a 'Primary Vertical' and 'Secondary Vertical'.
[274]
This will insert the two boxes here on either side.
[278]
I'm just going to type in, our primary axis is blood ...
[281]
lactate in mmol.
[283]
The secondary axis is heart rate in bpm.
[288]
It's always good practice for you to ensure you include a ...
[292]
title, where it's needed.
[295]
In assignments, obviously it might be that you ...
[298]
may have figure info, so do not need a title at the ...
[302]
top. However as good practice ...
[305]
would always be to include horizontal axis titles where ...
[310]
possible also your vertical axes as well.
[314]
This has just been a quick tutorial,
[317]
just to show you how you would plot two
[320]
independent/individual vertical y-axes within the ...
[324]
same chart. Again,
[325]
it can be used on any examples of data,
[328]
I just chose blood lactate and heart rate. Thank you.
Most Recent Videos:
You can go back to the homepage right here: Homepage