Use High-Low lines in a chart
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel Charts, Chapter 6: Hi-Low Lines.
Oh hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
There's a couple of different types of lines that we can add to charts, that I want to talk about here as we're talking about chapter 6.
So, I have four different series A, B, C & D and the first thing I want to talk about is the hi-low lines. Now, I see that this is going to run off the screen here.
So I actually, added the lines drop down up here to the Quick Access Toolbar.
High Low lines or add those in and what the High Low lines does is, it for every single data point, it goes from the highest series down to the lowest series.
You know what, let's go.
We're at the grid lines here.
So, it goes from the highest series down to the lowest series. So, you know, here item B lowest, here item D is highest and so I would always go from the high to the low. Now, let's undo that and compare that to something else called Up Down bars, Up Down bars are found under Analysis > Up Down bars. So I added that to Quick Access Toolbar. Up Down bars are kind of curious and that, the up down bars always, always go from the first series in the chart to the last series in the chart and they're one color if, if it's going from A being on top and a different color if they're going from the first series being on the bottom.
All right so, kind of curious, the way this works.
It only works from the first to the last series you have to be really careful about what you're charting there.
Especially, if you have a multiple series.
Probably, what you are looking for instead, is the High-Low Lines...
I wanna thank you for stopping by. I'll see you next time for another netcast from MrExcel.
Excel Charts, Chapter 6: Hi-Low Lines.
Oh hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
There's a couple of different types of lines that we can add to charts, that I want to talk about here as we're talking about chapter 6.
So, I have four different series A, B, C & D and the first thing I want to talk about is the hi-low lines. Now, I see that this is going to run off the screen here.
So I actually, added the lines drop down up here to the Quick Access Toolbar.
High Low lines or add those in and what the High Low lines does is, it for every single data point, it goes from the highest series down to the lowest series.
You know what, let's go.
We're at the grid lines here.
So, it goes from the highest series down to the lowest series. So, you know, here item B lowest, here item D is highest and so I would always go from the high to the low. Now, let's undo that and compare that to something else called Up Down bars, Up Down bars are found under Analysis > Up Down bars. So I added that to Quick Access Toolbar. Up Down bars are kind of curious and that, the up down bars always, always go from the first series in the chart to the last series in the chart and they're one color if, if it's going from A being on top and a different color if they're going from the first series being on the bottom.
All right so, kind of curious, the way this works.
It only works from the first to the last series you have to be really careful about what you're charting there.
Especially, if you have a multiple series.
Probably, what you are looking for instead, is the High-Low Lines...
I wanna thank you for stopping by. I'll see you next time for another netcast from MrExcel.
