Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 809

Select the three-dimensional bar chart. You will now see the sales
data in a three-dimensional view. Click Next in the Chart Wizard.
5. Some end users prefer to see the graphical representation of the
data in the chart along with the numerical data embedded within the
same report. The Pivot chart allows you to display the data within a
table beneath the chart. In the Chart Wizard - Chart Options click the
Data Table tab as shown in Figure 15-32 and select the option to
"show the data table" to display the numeric values of the pivot table
with the pivot chart; then click Finish.
Figure 15-32
Typically, end users print the charts for meetings or use them in power
presentations. In order to remove the axis information, click the Pivot table
toolbar and under the Pivot Chart drop-down select menu item "Hide
PivotChart Field Buttons." You will see the pivot chart containing a three-di-
mensional view of the sales data along with the pivot table as shown in Figure
15-33 .