Join Richard Harrington for an in-depth discussion in this video Using the Recommended Charts option, part of Excel 2013: Working with Charts and Graphs.
- Sometimes, you are overwhelmed with the possibilities.…Microsoft offers a lot of different chart types,…and you might not know which one is right.…Fortunately, it gives you a little bit of guidance…with the recommended charts option.…Let's go back to our original data set,…and create a new chart from scratch.…I'll highlight the information again,…so it knows what information I want to put into that chart,…and when I choose "INSERT,"…you'll note that besides giving me choices…of all the different chart types,…keep in mind we'll explore more of these later,…there is a button that's quite large…called "Recommended Charts."…When you click this, the application attempts…to analyze your data and make some suggestions.…
Now, because it saw percentage signs,…it came up with a pie chart, but remember,…in this case, we're not comparing the data as a whole.…People were not limited to making a single choice,…so, because of this, the pie chart…is not a very good option to show the overall data.…But, if we take a look here at the recommended charts,…
- Explain the steps to take to create a chart in Excel.
- Recall the options for customizing an existing chart within Excel.
- Determine which chart type fits best with a set of data.
- Summarize the process of creating a table.
- Identify strategies for clarifying a table.
- List the steps to take to add SmartArt to a project.
Skill Level Intermediate
1. Chart Essentials
2. An Overview of Chart and Graph Types
3. Displaying Data with Tables
4. Working with SmartArt
Adding a SmartArt graphic3m 50s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.