Join Gini von Courter for an in-depth discussion in this video Use data bars, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- This version of our January wholesale spreadsheet…is called Data Bars,…and data bars are another way we can provide information…through conditional formatting.…We're focusing in this instance on the data…about sales of K-Eco Energy Bulbs in different wattages,…and I've created a chart on the right…to try to illustrate this data.…Notice that in this version of the spreadsheet…we have the full numbers displayed,…not the numbers in thousands.…These are our actual units sold.…
And when I look at this information and I look at the chart,…I almost want to check out.…It just doesn't help me that much.…What I'd like to do is have an easier way…to compare the values without having to flip back and forth…visually from the chart back to my data.…What I'm going to do then is select the data…that I want to conditionally format.…Remember again that I don't want to include totals,…for example, because the total is a roll up…of all of the specific information from each of the regions.…
Let's go to Conditional Formatting and choose Data Bars.…
- 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.