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.…
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.
- 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