To find annual production in column F. To draw column chart of production of Rice & Wheat for 4 years. To draw PIE chart for the production of Year 2002. (Excel-2007)

Year wise productions (In million tons) of Rice, Wheat, Jawar and Bajra have been entered in a Worksheet as shown below. 

Based on these values, write steps

•                To find annual production in column F

Enter the formula,

=SUM(B2:E2) in cell F5, and then press enter key,

using the fill handle of cell F5, copy the formula to cells F6 :F8 by dragging the fill handle up to cell F8.

•          To draw column chart of production of Rice & Wheat for 4 years.

To draw column chart ,

Select range of cells B4:C8, now click on INSERT tab, in Insert tab click on column chart from CHART group, from sub chart select first sub chart.

Now select data source option from CHART TOOLS. Data source dialog box appears, to select year as  horizontal axis labels,click on edit and select range of cells A5:A8 and click on Ok.

•          To draw PIE chart for the production of Year 2002.

To draw 3D Pie chart for the year 2002, select range of cells B4:E4, keep the control key pressed and now select range of cells B6:E6  click on INSERT tab,in Insert tab click on PIE from CHART group, from sub chart select 3D Pie chart.

Related Posts by Categories