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.…
Released
3/8/2017- 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
Share this video
Embed this video
Video: Summarize data using charts