In this workout, we're asked to create a stock price history chart showing stock prices in a line, a trend line, and daily volumes. We'll keep the volumes simple in this workout.

The first thing I need to do is select all of the data. You can see that we've got lots of dates, and then share prices on those dates and the volume of shares traded. There are many, many lines here, so I'm going to press control and then the down arrow, and that jumps to me down to row 256. I then want to select it all, so I press the shift button, hold the shift button, and then the left arrow. And now I'm going to press and hold control and shift and the up arrow to select all of it.

I need to insert a chart. I'm going to go for a insert line or area chart, and it's the first one I want.

Now in blue I've got my share price line, it's very difficult to see any movement going on there. And then in purple I've got the volume and we didn't want that as a line. We wanted it as a bar chart or column charts. So I just need to click on something in the chart. I've clicked on the volume chart here and I right click and I want to change series charts type.

Now this has defaulted down to combo for me. It may have defaulted to line for you, so if you go down to combo, that's where we need to be.

It's now suggesting different chart types. Now the price, I wanted it to be the line, so I'm going to change it away from what it's currently on to line. Great. That's back to what it was. The volume. that's the one we want to change. I'll go for the top left hand corner, the clustered column, that looks a bit nicer. I'd like to move one of my series onto a secondary axis. On the right hand side, it doesn't really matter which one you go for. In this case, I'll go for volume and I tick under the secondary axis.

Now I've got my volume on the right hand side axis and my share price on the left press. Okay, that looks fantastic. I want to now add in the trends line for the share price. So I click on the share price line, right click add trend line.

I've gone with a linear trend line, and if I scroll down a little bit, I also would like to display the equation.

I can't quite see the equation. It's kind of been covered up by some of the line, so I click on it. I'll just drag it up a little bit. If I go to the home ribbon, I can change how it looks a bit. I'd like to change it to a nice blue, make the font 10 and then make it bold. The last thing we need are some axis titles. I can't tell if this is the volume or the share price. If I look at the numbers underlying here, I can see the share prices is all around 200, whereas the volumes are a little bit higher. They go up into the thousands, so I know that this left hand axis must be the share price. Click somewhere in the charts, then go to the chart, design ribbon, add chart elements, access titles, and I want the primary vertical. And I just start typing price and it appears. I want to do exactly the same thing again, just short. I've got something selected here, chart design, add chart elements, access, title, secondary, vertical, and I can now type in volume. And that chart is done.