Excel® 2013 Charts and Graphs

9. Using Sparklines, Data Visualizations, and Other Nonchart Methods

In This Chapter

Fitting a Chart Into the Size of a Cell with Sparklines

Using Data Bars to Create In-Cell Bar Charts

Using Color Scales to Highlight Extremes

Using Icon Sets to Segregate Data

Creating a Chart Using Conditional Formatting in Worksheet Cells

Creating a Chart Using the REPT Function

Next Steps

Edward Tufte wrote about small, intense, simple data words in his 2006 book, Beautiful Evidence. Tufte called them sparklines and produced several examples where you could fit dozens of points of data in the space of a word. Six months later, the Excel team began planning for Excel 2010 and Tufte’s concepts made it into Excel 2010.

Sparklines appear on the special drawing ...