Database Reference
In-Depth Information
Figure 15-28. A simple PivotChart
The items inside the chart are designed to be individual chart components and can be moved around as
well. Give it a try in the following exercise!
exerCise 15-3. Creating a piVottable Chart report
in this exercise, you make a pivot table chart to create your own report like the one shown in figure 15-30
by connecting the ssAs cube and using PivotChart.
1. Using the workbook you created in Exercise 15-1, navigate to sheet2 by clicking the
tab at the bottom of the screen.
2. Change the PivotTable to show salesQuantities by stores, as shown in figure 15-26 .
3. navigate to the PivotTable Tools tabs on the office Ribbon, and select the options tab,
as shown in figure 15-26 .
4. on the options tab, click the PivotChart button (figure 15-26 ).
5. select the first column chart template, as shown in figure 15-27 . Click oK to create
the PivotTable chart.
6. Move the PivotTable chart alongside the original pivot table, as shown in figure 15-28 .
7. save your report using Excel's file save menu item.
now you have created a report with both a PivotTable and PivotChart. let's move on to formatting the report,
so leave Excel open for now.
 
Search WWH ::




Custom Search