Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
As you continue to work with Excel 2013, you'll begin to realize how Microsoft has made it a little more intuitive. You're going to get help along the way including with this new feature we're going to look at next, Recommended Charts. When you select data, Microsoft is going to help you pick the right chart for the type of data you've selected. So, we'll continue to work with our No Obstacles Sport - July 2012 Sales Report. If you you've been following along, all we're going to do is select our data next. Now, if you jump to this lesson, you want to get caught up, go to your exercise files, open up No Obstacles Sport - July 2012 Sales Report2.
You'll see exactly what I see and we're going to select our first column of data which contains our Date. So, let's go right up to the heading, column heading A and click there. That selects the entire column. We also want our Price column. So, we'll go over to column heading E, while holding down Alt and Ctrl, we'll click that column header to select it as well. So, now we have two columns of data and we're ready to create a chart. Well, Microsoft already has an idea of what types of charts would best suit the data we have selected. So, let's go to Insert and over here in the Charts section, you'll notice something new, Recommended Charts.
Give that a click and you'll see a dialog box with two tabs, Recommended Charts which are displayed down the left here and All Charts. So, if don't like any of the recommendations, no problem, just go to All Charts and select the chart that you like best, just like you always did in previous versions. But here under Recommended Charts you'll see at the top, this one is highlighted and we see a preview over here of the Scatter Chart. Now, based on the scale that's being shown here, we don't see any variation. So, we would have to do a little bit of work with our scale; same thing for the Line Chart.
The third one which is a Stacked Area Chart does show all of our fluctuations, and if we go to the fourth one, you can see it's like the others, we would have to adjust the scale using the Clustered Column. So, let's go with the third one, our Stacked Area. We select it by clicking and then click OK. Now, it's going to create the chart for us right on top of our data. We can go to the border though and right on the border when you see the four-sided arrow, click and drag it off to the right. We'll just move it off to the right a little bit. It looks good. You'll notice something's happened on the Ribbon. We're looking at Chart tools now with the Design tab selected.
So, we can actually hover over these different designs to get a preview, and if we see one that we like better than the original, all we have to do is select it by clicking. I think I'm going to go with this one here, Style number 6. Give it a click and I have all of my other Chart tools available to me here, just as though I created this chart from scratch. But with Recommended Charts, I have a pretty good suspicion that I'm going to be selecting the right type of chart for the data I had selected. I'll just click off in a cell in behind to deselect our chart and continue from here.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91069 Viewers
80 Video lessons · 138146 Viewers
59 Video lessons · 56954 Viewers
52 Video lessons · 70583 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.