Microsoft Office Tutorials and References
In Depth Information
Figure 6-104. Entering the name of the pivot table
Select the “Sales Amount” column cells on the PivotTable.
Select Home ➤ Conditional Formatting ➤ Data Bars, and select one of the options
shown. (See Figure 6-105 .)
Figure 6-105. Selecting a style for the data bars
Click on cell B1. This should be the All Periods value for the Date.Fiscal filter. Be sure
to select the value cell (B1), not the label cell (A1).
Click ANALYZE from the Ribbon menu, type “Date” into the name box, and press Enter.
(See Figure 6-106 .)
Search JabSto ::