Chapter 21. Advanced Charting Techniques

Selecting Chart Elements

Repositioning Chart Elements with the Mouse

Formatting Lines and Borders

Formatting Areas

Formatting Areas

Working with Axes

Working with Data Labels

Formatting Data Series and Markers

Modifying the Data Source for Your Chart

Using Multilevel Categories

Adding Moving Averages and Other Trendlines

Adding Error Bars

Adding High-Low Lines and Up and Down Bars

THE ribbon-based user interface in Microsoft Excel 2010 provides quick access to a wonderful assortment of chart types, layouts, and styles. With these tools (see Chapter 19) and a few mouse clicks, you can knock out a knockout chart in record time. Chances are, though, that before long you are going to need some of the additional formatting ...

Get Microsoft® Excel® 2010 Inside Out 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.