Pivot Chart Complete the following tasks to create a pivot table and pivot chart

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Pivot Chart Complete the following tasks to create a pivot table and pivot chart for the Excel workbook PivotDemo Download PivotDemo: 1.Select the data range that you desire for pivot table (A1:E121) and then click insert tab ->Pivot Chart option -> PivotChart & PivotTable option. Excel will display the Create PivotTable dialog box. 2.Choose to put the PivotTable in a New Worksheet and click OK. Excel will display a blank pivot table report where you can add the fields you desire. 3.Place checkmarks next to region, sales and year fields. Leave “region” in the rows area and move sum of year to the columns area. 4.Change the value field settings for sales by clicking the drop down arrow on sum of sales ->value field setting. Excel will display the value field setting dialog box. 5.Choose average from the options and click OK. The pivot table will now display average sales amounts by year for each region. Notice both a pivot table and a chart will be created simultaneously. 6.Give your graph an informative title and change the color scheme of the bars (your choice). 7.Copy and paste your chart into a word document & provide a managerial report discussing any insights that are gained from using a pivot table and chart (using complete sentences) 8.Submit report as a word document or pdf file.

For This or a Similar Paper Click To Order Now