22. Using Data Visualizations and Conditional Formatting
Many people feel their eyes glaze over when they encounter a screen full of numbers. Fortunately, Microsoft offers data-visualization features to Excel that make those screens full of numbers easier to interpret.
The following are some of the possibilities in data visualization:
Adding data bars (that is, tiny, in-cell bar charts) to cells based on the cell value. In Excel 2016, data bars can be negative, include an axis, and have new scaling options.
Adding color scales to cells based on ...
Get Excel 2016 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
