Inserting recommended charts

- Sometimes when adding many, many rows…and columns of data, it's difficult to analyze that data…to pick up on trends, for example,…and that's where a visual representation…of the data can come in handy,…but that means creating charts or graphs,…and there's a very easy and fast way…to do it here in Excel 2016.…We're going to explore it now…with our Landon Hotels Revenue sheet here for 2014.…And we're going to focus on the data…for Q1 for the different locations.…You can open up our RH_Revenues0207…if you're getting caught up.…

Now, one thing that could be a problem is…any blank rows or columns, when we go to select the content,…we want to create the chart from.…So let's go to row 6 here, and we'll right-click right…on the 6 to delete that empty row.…Now, things do look a little bit cramped,…so we can go in between 5 and 6…when we see the double arrow.…Click and drag down to double up the row height,…and then, we'll click right on the 5…so that everything here is centered vertically.…We'll go up to the Alignment button to choose Middle Align.…

Resume Transcript Auto-Scroll

Author

Updated

5/6/2017

Released

12/2/2015

This beginner-level course will introduce new users to the Office 365 version of Excel 2016. Author David Rivers covers the interface, creating and opening workbooks, adding text and numbers, working with formulas, basic formatting, inserting charts and graphics, and sharing and printing workbooks so that you have a great foundation in the world's most popular spreadsheet program.

Topics include:

What is Excel?

Creating and saving workbooks

Adding formulas and functions

Using AutoFill

Formatting, text, numbers, dates, and times

Merging cells

Inserting charts and pictures

Sharing and printing workbooks

Skill Level Beginner

1h 18m

Duration

375,100

Views

Show MoreShow Less

Q: This course was updated on 04/24/2017. What changed?

A: The following topic was updated: sharing workbooks using online options.