Assignment Instructions

You want to display a key value from the PivotTable on the

Sales Data worksheet.

Display the Sales Data worksheet. Insert the GETPIVOTDATA

function in cell $F1$ to display the overall average selling price in

cell B$9$ in the PivotTable on the Selling Price worksheet.

You decide to create a PivotChart to illustrate the PivotTable

data visually.

Create a clustered column PivotChart from the PivotTable on

the Selling Price worksheet. Move the chart to a chart sheet

named Sales Chart.

The chart should have a meaningful title. You will also modify

some chart attributes.

Change the chart title to Average Selling Price by City and

apply Dark Blue font color. Remove the legend. Apply Dark Blue

fill color to the data series.