In this movie, I will show you how to create sparklines, which are word-sized charts invented by designer Edward Tufte.
- [Instructor] You can use standard Excel charts…and pivot chars to summarize large data collections quickly.…However, you might not always want to summarize…a huge range of data or to have your chart…take up a lot of space in your dashboard.…In this movie, I will show you how to create…sparklines, which are word-sized charts…invented by designer Edward Tufte.…I'll demonstrate how to create sparklines…using the Sparkline Excel workbook.…You can find it in the Chapter One folder…of your Exercise Files collection.…I have an Excel table on this workbook's single worksheet,…and it has monthly revenue data…for January through December of a year.…
It also has a quota target…and how the hotel in this case…performed as a comparison to the target.…I could summarize this data using…a standard chart, but let's say that I am constrained…in the amount of space I can use,…and I want the visual summary to appear…in a single worksheet cell.…I can do that using a sparkline.…I'll start by clicking the cell…where I want the sparkline to appear.…
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