Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Figure 15-8: With the new arrangement in your pivot table, you get a pivot chart that makes sense.
Limitations of pivot charts
Overall, the look and feel of pivot charts in Excel 2013 is similar to the look and feel of standard
charts, making them much more of a viable reporting option. However, a few limitations persist in
this version of Excel.
➤ You cannot use XY (scatter) charts, bubble charts, or stock charts when creating a pivot chart.
➤ Applied trend lines are often lost when adding or removing fields in the underlying pivot
➤ The chart titles in the pivot chart cannot be resized.
Although you cannot resize the chart titles in a pivot chart, making the font bigger or
smaller indirectly resizes the chart title.
Using conditional formatting with pivot tables
In Excel 2007, Microsoft introduced a robust set of conditional formatting visualizations, including
data bars, color scales, and icon sets. These new visualizations allow users to build dashboard-style
reporting that goes far beyond the traditional red, yellow, and green designations. What’s more,
conditional formatting was extended to integrate with pivot tables, which means that conditional
formatting is now applied to a pivot table’s structure, not just the cells it occupies.