From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Create charts

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Create charts

“

- [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. and how to create a new chart worksheet.

Contents