Join Gini von Courter for an in-depth discussion in this video Illustrate trends with sparklines, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- A sparkline is an itty-bitty, teeny, tiny chart…that is placed in the background of a cell.…Sparklines are used to show trends.…Increases and decreases, cyclical information,…and they are really easy to create.…Each sparkline is illustrating a row of data.…So, if I place sparklines here,…they will be illustrating this data block right here,…which is our solar panel sales.…Let's take a look at how easy it is to insert a sparkline.…
Simply go to "Insert."…And there are three types of sparklines.…Line, column, and win/loss.…I'm going to choose a column sparkline.…It asks for my data.…Your selecting just the values, not the titles.…And then choose where we want the sparklines to be placed.…And I'm going to put them right here.…Very close to my data.…I could put them down here but that would really be a waste…because I'd like people to be able to…read across the row and see the sparkline.…
As a matter of fact, if I didn't need totals in this cell,…I wouldn't include it.…Let's go ahead and drop our sparklines in right here.…
- Identify the theme used by the default paste option.
- Recall what is embedded when you copy an Excel table and then embed the table in a PowerPoint presentation.
- Recognize the actions that may compromise data or yield incorrect results if a data table is missing descriptive labels.
- Recall the benefits of using a slicer over using a filter.
- Name a great way to illustrate the timeline and progress of a project.
- Explain what PivotTables do to tabular data.