Home

How to Format the Plot Area of an Excel Pivot Chart

|
|  Updated:  
2016-03-26 07:11:21
|   From The Book:  
No items found.
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon

If you right-click a pivot chart's plot area — the area that shows the plotted data — Excel displays a shortcut menu. Choose the last command on this menu, Format Plot Area, and Excel displays the Format Plot Area pane, as shown here.

This dialog box provides several collections of buttons and boxes you can use to specify the line background fill color and pattern, the line and line style, any shadowing, and any third-dimension visual effect for the chart.

Add fill colors for a plot area here.
Add fill colors for a plot area here.

For example, to add a background fill to the plot area, select Fill from the list box on the left side of the Format Plot Area pane. Then make your choices from the radio buttons and drop-down lists available.

It would take pages to describe in painful and tedious detail the buttons and boxes that these formatting choices provide, but if you're really interested in fiddling with the pivot chart plot area fill effects, just noodle around. You'll easily be able to see what effect your changes and customizations have.

About This Article

This article is from the book: 

No items found.

About the book author:

Stephen L. Nelson, MBA, CPA, MS in Taxation, is a CPA in Redmond, Washington, where he provides accounting, business advisory, and tax planning and preparation services to small businesses. He is the bestselling author of 100-plus books about how to use computers to manage personal and business finances.