Using charts to visually display data can be very effective. In this video, learn how to create charts from a data range, create charts using the Quick Analysis Tool, and create chart sheets.
- [Instructor] Charts are a great way to visually share the information in your workbook. After watching this video, you'll know how to create a new chart, use a Quick Analysis tool and create chart sheets. Let's jump right into our create workbook, and take a look at our data. This is our production data for 2019 for all the cakes that we have created. Now, I mentioned that there are a couple of different ways to create a chart. Either just using the insert chart window, or once I have the information selected, this is my Quick Analysis tool. So let's take a look at that first. If you haven't been in here before, come in and take a look at the different functionality that's available to you in Excel. For this video, we're just going to focus on charts. These are the recommended charts. Excel has looked at my data and said, probably just a clustered column chart would be fine. I can however, click the More button, and look at again, the recommended charts with a nice display so I can preview my data. Or if I click on All Charts, I can then really decide, do I want to use a column chart, a line chart, bar. Look at all these different chart types we have available to us. Let's stick with a column chart. Clustered column and click OK. Here's our data in a chart format. Now, it's great that our data is formatted as a table, because we can use our table filter to filter the information in our chart. I'll use the drop down menu and click Select All. And let's just take a look at our quarter and half sheets for our chocolate and white. And now we just have four products displayed. So that's how you can filter the information. Now, we also have great slicers that we can use. Under your Insert tab and Filter group. Click on Slicer. And we have a slicer available for each of the columns in our table. I'll select product. And let me move this up. Click OK. So this is your slicer. These are great tools available to us. So we see that the ones that are highlighted are the ones that are being shown. Now, I can clear the filter clicking here, or I can hold down my Shift key on my keyboard and add additional products. And as soon as I let go of my mouse, they're added. Now, we can move this chart to another worksheet by selecting the chart and going to Chart Tools, Design tab. Over on the right-hand side, Move Chart to a new sheet. We'll give it a different name than the current one. Let's call it Production 2019. And click OK. And that's how you can move it to a new sheet. Now, if we go back to our data, clear the filter so we're seeing all of the information. I'll go ahead and select the data one more time, With the data selected, I'll press F11 on my keyboard, and that quickly, a new worksheet was created with a great column chart on it. So now you know three different ways that you can quickly create a chart, and how to create a new chart worksheet.
- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam