From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating charts
- [Instructor] Creating a chart, which is nothing other than a visual representation of numeric data, is pretty easy in Excel. You can quickly embellish a chart with a variety of visual effects. We're looking at a worksheet called Creating Charts in the workbook 07 Charting. I'd like to represent this information here in columns D through I, as a chart. Most of the time when you've got data, you've got a row on top that defines what's in the cells below it and a column on the left hand side that does the same thing for the rows. We do have totals here. There's a general rule, but certainly not an ironclad rule, when you're highlighting data, to be shown on the chart, don't include the totals along with the detail. In other words, highlight, for example, just this data here. There's a great keystroke shortcut, if you're in a hurry, Alt + F1, that's using the function key, F1. The data's highlighted. Alt + F1. Immediately, you'll see a chart, on the current sheet. Often, it will overlap…
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.