Microsoft 365 Excel Beginner (2023): Plots and Charts

Name: Microsoft 365 Excel Beginner (2023): Plots and Charts
Author: Bob Akbar

Learn how to display results and graphics

Preview the first lesson free — get full access to all 4 lessons.

Course: On-Demand

Hello, my name is Bob Akbar, and. In these lessons, I will show you how to do Plots and charts, which consists of charts, plots, pictures and shapes. In this lesson, you will learn Charts. You will notice that we have three. Data tables here. And we can select. Any of them, including the header. Go. To insert, and it will give us. Recommended charts as well as a range of options for charts. So let's start off with the recommended charts. You will notice it asks us if. These are helpful, because not all of them are. If you take a look at the. Commission, compared to the months, that is a useful chart. However, as we scroll down, you will. Notice the average work days versus the. Average days and the dollar amounts. That really does not give us much that is useful. So let's go with the commission one that is useful. And we will press Insert chart. And here it is. Now, you will notice I have created. Another worksheet down here, and it is called Charts. And what I'm going to do is. I'm going to right click and cut. I'm going to go to my charts. Right click and paste. What this does is this separates our. Data from the actual chart, so that. Our data, it may be proprietary, it may have private information, will remain separate from the data that we display. Now we will close the recommended charts and we will double click on the chart itself. You will notice now, when we do. That, we get some options here, and. One of them is, do we want the chart title? That sounds good. If we turn it off, you notice it immediately updates here and it takes it away. So you can get a preview. As you're doing this, you can change the title where you would like it positioned. An overlay puts it just like it. Says on the inside above, puts it separately. We can change the fonts. And we. Can change the sizes. And it shows. Us, as we do that, what happens. Next. We have the legends, and that's for these guys. You will notice it'll show us the. Line is the commission and when it. Goes, what the percentage is versus what. Month is, what it is showing us. This is useful if we have multiple. Items that are graphed. If we only have one, we can turn it off. It also shows us the minimums and the maximums. And if you notice, it is the. Dates that we have that are formatted. Into the month format. And we can change the number of the units, the major and the binary units. If we had multiple years, we would change the major units to years, so it would separate the years from the months. And the ticks. It gives us these ticks. Right there you see the actual lines, and if we take them, put none, they go away. We can also do the data in reverse order. If we're trying to show something that. We want the data in reverse. We. Have other the grid lines and we have the vertical axis. And you see how it has the different units of how it's putting the calibration in there. And we have different places we can. Put this to next to the access high. Low. And we can use different colors if we'd like. We could use a fill. There it is. We're trying to highlight those. And we can also do things with the actual series where we can add data labels. And you see how now each data. Point, it actually shows us what the percentages were. And a trend line. This shows us kind of the best fit graph. If you're looking for that. It is under the trend line, where. It shows us the best fit graph. For how things are trending and.

Beginner Provider : Bob Akbar 4 Lessons · 29m in Arabic, German, English, Spanish, French, Portuguese, Chinese

Course Description

Most users want to present data findings in a visual way that is easy to understand. For this reason, charts, plots, pictures and shapes are useful. In this Excel course, we’ll explore powerful tools for beginner users to present their data.

When using charts, the data is related on both axes. When using plots, we are showing points that may not be related to a dependent variable. Both of these methods provide visual displays. There are effective methods for testing different previews to see which type of display provides the best representation of your data set. Charts and plots can be customized with extensive details to provide all the tools necessary for professional presentations. Finally, the ability to use pictures and shapes can add richness and clarity to your presentations. You will learn how to draw an audience’s attention to specific areas of your data tables and make ideas stand out.

What You'll Learn

Distinguish charts from plots and recognize when each is appropriate for representing a data set
Create and customize charts in Excel across both axes for related data
Build plots to display points that may not relate to a dependent variable
Identify Excel's graphics options and apply layering to make ideas stand out
Add pictures and shapes to draw an audience's attention to specific areas of data tables
Test different display previews to find the best visual representation of your data

Key Takeaways

Charts, plots, pictures and shapes are useful tools for presenting data findings in a visual, easy-to-understand way.
Charts relate data on both axes, while plots show points that may not be related to a dependent variable.
Charts and plots can be customized with extensive details to support professional presentations.
Testing different previews helps determine which type of display best represents a given data set.
Pictures and shapes add richness and clarity and can draw an audience's attention to specific areas of data tables.