To create a straight-line chart. To construct 3-D pie diagramTo draw Bar diagram for total pass in Excel-2007

The following data has been entered in a worksheet

•          To create a straight-line chart.

Select range of cells A1:E4 ,Now click on INSERT tab, in Insert tab click on LINE from CHART group, from sub chart select first sub chart. 

•          To construct 3-D pie diagram for the year 1995.

Select Range of cells D2:D4. click on INSERT tab, in Insert tab click on PIE from CHART group, From sub chart select 3D Pie chart.

Now select data source option from CHART TOOLS. Data source dialog box appears,

To select horizontal axis labels, click on edit and select range of cells A2:A4 and click on Ok. 

 

•          To draw Bar diagram for total pass of all the 4 years.

First we must find total pass for all the four years.

Enter the formula,

=SUM(B2:B4) in cell B5 and then press enter key,

Using the fill handle of cell B5, copy the formula to cells C5 :E5 by dragging the fill handle up to cell E5 .

Now click on INSERT tab, in Insert tab click on bar from CHART group, From sub chart select FIRST chart.

Now select data source option from CHART TOOLS. Data source dialog box appears.

To select horizontal axis labels, click on edit and select range of cells B1:E1 and click on Ok.

Related Posts by Categories