From the course: Excel 2013 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Exploring chart types - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Exploring chart types
Excel has over 50 different chart types, so it's not always clear which chart is best for the kind of data you're trying to show. We're using the sheet called Chart Types, let's select the data over in columns A and B and simply press Alt+F1, a quick way to create a chart. This gives us a Column Chart. Is this the best way to display this data? When you create a chart, recognize that the Chart Tools ribbon is activated, and we've got a Design tab and a Format tab at the top of the screen. Off to the right we see a choice called Change Chart Type. We can easily get a preview here of what this chart might look like, if for example it were a Bar Chart. Click here, we see some examples of that, we can slide over it, would this be better as a Pie Chart or how about a Line Chart? We can get a quick preview here and decide what looks best. If our starting data is multi- dimensional, like the data in column D, we get more choices here and more previews, so let's escape from this option…
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.