Bringing it all together - Business Intelligence in Microsoft SharePoint 2013 - page 325

To set the default view for the Web Part, in the Properties pane (see Figure 10-20), in the
Named Item text box, type SumSales .

5.

This works only if you have labeled the PivotChart in the previous procuedure.

FIGURE 10-20 The Web Part Properties tool pane configuration dialog box.

At the bottom of the Web Part Properties pane, click either OK or Apply. 6.

The Web Part displays the chart named Chart 1, as shown in Figure 10-21.

FIGURE 10-21 The Excel Web Access View drop-down list.

Notice that the Web Part no longer displays this page as a spreadsheet. Instead, it displays each
item, one at a time, in the Web Part. This viewing mode is referred to as the Named Item View . When
users expand the View drop-down list, they can choose to display any of the other items in the
workbook.

The Named Item View is the view used in most Web Parts because most people just want to see
the parts of a workbook that are interesting and related in a dashboard.

Therefore, for the case in which the author chose to show only a set of items from the workbook,
the Web Part shows whichever is the first item in the workbook (sorted alphabetically), even if you
don't specify the name of an item in the Named Item Web Part Text box. However, you can also
specify which item should appear first in the workbook by using the Named Item text box in the Web
Part Properties pane.