From the course: Excel: Charts and Graphs In Depth
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Managing your source data - Microsoft Excel Tutorial
From the course: Excel: Charts and Graphs In Depth
Managing your source data
- [Instructor] So let's talk about how to manage your source data. Now to really manage your source data, we're going to use a tool in Excel called an Excel Table. And you could do a lot of really cool things with an Excel Table, like make the chart below. I'm going to show you how to manage your source data and then I'm going to show you how we can use an Excel Table to make one of these types of charts. All right, so let's start with this basic data right here. We have our Sales and Returns. I'm going to go ahead and click Insert, having highlighted A1 through C4, and insert a new 2D Bar Chart like that. And I'll just make it a little bit smaller so it fits. Okay, so let's say in cell A5, the Midwest region has called, their numbers are in, right? So I put in 100 here, they only had five returns. Well, nothing happened to the chart, right? And let's say I now have imagined 100 of these. This is a real issue and it's a…
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.