OAT-Record-06) Bar and Pie Charts

 

AIM: The ABC Company shows the sales of different product for 5years. Create BAR Graph, 3D and Pie chart for the following.

A	B	C	D	E	F
1	Year	Production-1	Production-2	Production-3	Production-4
2	1989	1000	800	90	1000
3	1990	800	80	50	900
4	1991	1200	190	40	800
5	1992	400	200	30	1000
6	1993	1800	400	40	1200

 

Procedure: -

STEP 1: 

    Enter into MS-EXCEL environment by choosing start àProgramsàMs OfficeàMS Excel.

STEP 2: 

    Now save the opened Blank document with the following step Office Button à save à Pie and Bar charts

STEP 3: 

    Write a given data entry to cells à Select or drag table (6X7) à Select ALL Borders.

STEP 4:

     Select a Cell ( C 1 to F 6 ) à Goto Insert Tab à Select the BAR Graph in 3D model.

 

 

NOTE: 

    Select Object and Right click the Object choose the Select Data option Edit Horizontal Axis Label Add Year in Table to Select value = B2, B3, B4, B5, B6 enter OK.

STEP 5: 

    Select a Cell (C 1, C 2, C 3, C 4, C 5, C 6) àGoto Insert Tab à Select the PIE Graph in 3D model.

PRODUCTION-1

 

NOTE: 

    Select Object and Right click the Object choose the Select Data option Edit Horizontal Axis Label Add Year in Table to Select value = B2, B3, B4, B5, B6 enter ok.

STEP 6: 

    Select a Cell (D 1, D 2, D 3, D 4, D 5, D 6) àGoto Insert Tab à Select the PIE Graph in 3D model.

PRODUCTION-2

 

NOTE: 

    Select Object and Right click the Object choose the Select Data option Edit Horizontal Axis Label Add Year in Table to Select value = B2, B3, B4, B5, B6 enter ok.

STEP 7: 

    Select a Cell (E 1, E 2, E 3, E 4, E 5, E 6) àGoto Insert Tab à Select the PIE Graph in 3D model.

PRODUCTION-3

 

 

NOTE: 

    Select Object and Right click the Object choose the Select Data option Edit Horizontal Axis Label Add Year in Table to Select value = B2, B3, B4, B5, B6 enter ok.

STEP 8:

     Select a Cell (F 1, F 2, F 3, F 4, F 5, F 6) àGoto Insert Tab à Select the PIE Graph in 3D model.

PRODUCTION-4

 

 

NOTE: 

    Select Object and Right click the Object choose the Select Data option Edit Horizontal Axis Label Add Year in Table to Select value = B2, B3, B4, B5, B6 enter ok.

STEP 9: 

    Goto Home Tab click Alignment.

STEP 10: 

    Press Ctrl+S or form the menu option click File-> Save.

STEP 11: 

    Press Alt+F4 or click Office Button-> Exit from menu to exit EXCEL.