In this video, learn how to use the Recommended Charts feature to choose a chart from a list of recommended charts that appear based on the type and amount of data you have selected in your worksheet.
- [Instructor] Sometimes when just looking at rows and rows…and columns and columns of numbers,…it can be difficult to understand…what's going on inside that data.…To get a visual representation of things like trends,…for example, we can use charts,…and that's what we're going to explore in this movie…with our Red30 Projected Revenues workbook,…Red30Revenues0206 if you're catching up.…Let's just zoom out using the minus sign on the Zoom Slider,…all the way to 80%.…Now, we do see a lot of numbers here.…
We can pick up on what's going on, such as trends,…by selecting data and creating a chart,…and there are many, many different types…of charts you can use here in Excel.…We could do a whole course just on charting,…but we're gonna focus on what Excel does…when you select data on a sheet,…and that is recommend charts for you…that will work with that selected data.…Let's see what I'm talking about here.…We'll start by going to the Europe row, row six,…and let's say we wanna create a chart…for just the Q1 data for Europe.…
- Explore efficient methods for adding functions and formulas.
- Format text, numbers, dates, and times.
- Save, share, and print your workbooks.
- Recognize how to freeze panes to control your view.
- Recall methods for protecting documents.