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:

Motorcycles: 12,778

1	To navigate to the legend section of the chart builder, choose Legend from the navigation list at the left.

2	Deselect Visible, as shown in Figure 14‑14.

Figure 14‑14

Legend section of Format Chart

3	Now you can add the legend information to the sector labels. Navigate to the value series formatting section, then choose Labels.

Figure 14‑15 shows Series Labels.

Figure 14‑15

Series Labels formatting options

4	To add the section name to the label, ensure that Category Data appears in the drop-down list in the Values area, then choose Add. Category Data appears below Value Data in the list, as shown in Figure 14‑16.

Figure 14‑16

Adding category data to a label

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.

Figure 14‑17

Category data precedes value data

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.

Figure 14‑18

Adding a label separator

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.

Figure 14‑19

Edit Format

Choose OK to close Edit Format.

8	To change the formatting attributes of the label text, choose Font Editor, as shown in Figure 14‑20.

Figure 14‑20

Opening Font Editor from Labels

Edit Font appears.

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

Figure 14‑21

Edit Font

2	Choose OK, and close Series Labels.

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.

1	In Leader Line Style, accept the default, Fixed Length. Change Leader Line Length to 20.

2	Explode the sectors, so there is space between them. In Slice, set By Distance to 3.

To make the chart more useful to the report users, you can add interactive features, such as hyperlinks and highlighting. You can add interactive features to the chart area, legend, marker lines, and to other parts of the chart.

Figure 14‑22

Editing leader lines and exploding sectors

You have finished creating and formatting 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 chart looks like the one shown in Figure 14‑23.

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.

Figure 14‑23

Completed tutorial chart