From the course: Excel: Charts in Depth
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Stock charts
- [Instructor] Excel has a chart type that allows us to make sense out of stock market type quotes. And on this worksheet called Stock Chart we've got four different kinds of data. And they actually represent the different stock charts that are available. Notice that they all have something in common, they have column called High, Low, and Close. We see that in each group. But the second group in also has a column called Open. The next group over, the third group from the left, has High, Low, Close, but it has Volume instead of Open. And the last group, the one on the right, has High, Low, Close, and then to the left of it, Volume and Open. Now, as a reminder as to where you find the Stock Chart option, the last worksheet in this workbook is called Chart Type Icons. I'll click it. And what we're seeing here is a depiction of what we see on the Insert tab in the chart area. And a quick look in here reveals…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.