Create PivotTable dialog box. Choose to put the PivotTable in a New Worksheet and click OK. Excel will display a blank pivot

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. 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. Place checkmarks next to region, sales and year fields. Leave "region" in the rows area and move sum of year to the columns area. 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. 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. Pivot table should have an informative title Graph should have informative title and axis labels. Feel free to update design/theme/color scheme for graphs. Copy & paste pivot table and graph neatly into Word. A brief description/explanation should accompany table providing any insights gained from using pivot table and chart

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?