From the course: Excel: Introduction to Charts and Graphs
Join today to access over 24,700 courses taught by industry experts.
Selecting data to display as a chart
From the course: Excel: Introduction to Charts and Graphs
Selecting data to display as a chart
- [Instructor] An Excel chart is a depiction of numerical information. If you don't have numbers, it's pretty hard to come up with a chart in Excel that would make any sense. But what you wouldn't know before creating a chart is when you are showing numbers, nearly always the numbers you're dealing with include either column headings like we're seeing here on this worksheet in row two. And often we have row headings as well over in column A. So if we wanted to depict this information in a chart, we would highlight data that includes that column A in this example, and also the data in row two. And typically we don't want to include totals along with detail. A quick look at some of the numbers here suggests if we were using the number 864, imagine a column 864 units high and over here's the number 44. That's about 20 times smaller. This is not going to be a very attractive chart, so typically you don't include totals. Now if you do, of course you'll just see that it looks kind of weird…
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.