Charts and Graphs - High-Low Lines: Podcast #1294

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Nov 29, 2010.
Today, in Episode #1294, Bill discusses 'High-Low Lines', 'Up-Down Bars' and why using 'High-Low Lines' may be the way to go...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by Excel-XL.
Cell Charts, chapter 6; Hi-Low Lines.
All right 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 wanna talk about, here is, we're talking about chapter 6.
I have 4 different series, A,B,C and D and the first thing, I wanna talk about is the High-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 and Low Lines will add those in and what the high level lines does?
is it for every single data point?
It goes from the highest series down to the lowest series.
You know, that's good [ ] So it goes from the highest series down to the lower series, so you know, here item B was lowest, here item D is highest and so it always go from high to low.
Let's undo that and compare that, to something else called Up/Down Bars.
Up/Down Bars are found under Analysis, Up/Down bar, so I add that to the quick access toolbar.
Up/Down Bars are kind of curious and that the Up/Down Bars always go from the first series in the chart to the last series in the chart and they're one color, 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 they have a multiple series, probably what you are looking for instead, is the High-Low Lines.
Now you understand the difference Hey, thank you for stopping by. I will see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top