In this video, staff author Jess Stratton shows users how to navigate through and insert charts in Excel. She'll also demonstrate how to use a sparkline.
- [Instructor] Just like the last video,…let's do a quick overview of charts in Excel.…The good news is that charts is one area…where Excel excels.…Let's work with this existing chart…and then I'll show you how easy it was…to create it in the first place.…The first thing I can do and the first thing…I'll need to do is resize it.…I'm going to hold the shift key down on my keyboard…and drag inward from the corner to make it smaller.…That's a little too small.…There we go.…I can also move it around the screen a little bit.…I'll drag it upwards, okay.…
If I click anywhere inside this chart,…I can see the exact row of data…that it's getting its values from.…Watch as I click on a different value.…And the rows itself in Excel will change.…This is a good way for me to narrow down…and find out where the data's coming from.…I can also move this chart to its own sheet.…I'm going to change to the Design ribbon tab…with the chart selected, I'll click Move Chart…on the right hand side of the screen…and I'm going to move it to a brand new sheet.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes