Task 6:
|
Refine the chart appearance
|
The chart includes labels that identify the data value being presented in each sector. A legend identifies which product line each sector represents. Though the legend includes useful information, it also takes up space and reduces the size of the pie, so you may have to make a trade-off. One possibility is to remove the legend and use sector labels to display the product line information. Using the sector labels instead of a legend is a better choice when report users cannot easily distinguish colors. Each data label displays category information (the sector name) and value information (the total number of orders for the sector). For example, the following label identifies the motorcycles sector:
1
|
To navigate to the legend section of the chart builder, choose Legend from the navigation list at the left.
|



You need to rearrange the label data, so the Category Data, which are the product line names, appear before the values in the chart labels. For example, you want the label to read Classic Cars, 35,582 instead of 35,582, Classic Cars.
5
|
Select Value Data, and choose Remove, then, in the drop-down list, select Value Data again, and choose Add. Value Data now appears below Category Data in the list, as shown in Figure 14‑17.
|

Now the labels display information in the correct order, but you still need to change the label appearance. When you use more than one kind of information in a label, you can use a separator between the different sections. The default separator is a comma.
6
|
To change the separator, in Separator, type a colon (:) then a space, as shown in Figure 14‑18.
|


To change the number format of the value part of the label, select Value Data in the list, then choose the Format Editor. In Edit Format, you can change the format of date-and-time or numerical data.
7
|
Select Standard, then change the value in Fraction Digits to 0, as shown in Figure 14‑19.
|



1
|
Change the font to Tahoma and the size to 11, as shown in Figure 14‑21.
|

9
|
Now you set a consistent length for the leader lines that connect the labels to the sectors. Figure 14‑22 shows where to find the leader line settings.
|
To make the chart more useful to the report users, you can add interactive features, such as hyperlinks and highlighting, as described in later sections of this book. You can add interactive features to the chart area, legend, marker lines, and to other parts of the chart.

10
|
To close the chart builder and see the chart element in the layout editor, choose Finish. Then, for the last time, choose Preview to preview the chart.
|
The completed chart shows the category names for each sector as well as the sector values. The size and organization of the chart make quick analysis possible, while still providing detailed data.
For example, the user can immediately see that the largest pie sector is Classic Cars, which has 35,582 orders, followed by Vintage Cars, which has 22,933. The two car sectors are larger than all other sectors combined. Other product-line groups, such as Trains, do not contribute significant numbers of orders.
