Microsoft Office Tutorials and References
In Depth Information
FIguRE 8-12 The Show Values As menu of Excel 2010.
To better understand how this works, look at Figure 8-13 to see the result of selecting, for
example, the % Of Column Total in the previous report.
FIguRE 8-13 Showing values as percentages of Column Total.
When you select this option, each value is replaced with the percentage of the value over
the total of the column. It is now much clearer, for example, that the Australia percentage
has a descending path even if the raw value of sales is growing.