Creating charts, which are visual representations of data collections, makes it easier to compare values quickly and identify overall trends that can be investigated in more depth.
- [Instructor] Human beings can easily comprehend…and compare several numbers at a time,…but comparing multiple values,…meaning more than about five or six,…can be very difficult.…Creating charts, which are visual representations…of data collections, makes it easier to compare values…quickly and to identify overall trends…that can be investigated in more depth.…In this movie I will show you how to create charts…using common data layouts that you'll find in Excel.…My sample file is the CreateChart Excel workbook.…
You can find it in the Chapter One folder…of your exercise files collection.…This workbook contains three worksheets.…I'm starting on sheet one and this contains…a straightforward data set.…I have monthly data, January through December,…of one year that displays room nights.…In other words the number of total nights…that rooms were rented in a hotel.…Let's say that I want to see this data over time.…So rather than try to keep the relative values…in my head let's say that I want to create a line chart.…
Author
Curt Frye
Released
3/8/2017Lynda.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.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Setting Up the Supporting Workbook
-
Define conditional formats7m 39s
-
Define icon set formats5m 33s
-
Summarize data using charts10m 12s
-
Create sparklines5m 3s
-
2. Creating a Dashboard Worksheet
-
Sketch your dashboard layout6m 20s
-
Create and manage cell links7m 45s
-
Link to a PivotTable cell4m 59s
-
-
Conclusion
-
Next steps1m 30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Summarize data using charts