Creating Charts in Excel.

In excel, you can create chart very easily using the Chart Wizard. The chart created can be inserted into the same worksheet or into different worksheet of same workbook.

To create a new chart, follow these steps.

  • Select the data for which you want to create chart. For example to create chart of student marks, the worksheet with data is given below.

Name

Math

Urdu

Total

lilly

25

50

75

Joni

20

55

75

jhon

22

60

82

Eizo

21

45

66

  • Click the Chart Wizard button on the Standard Toolbar.

  • Select chart type, chart sub-type from dialog box and then click “Next” button, a dialog box is displayed with a sample of chart you have selected.

  • Check the Data range and correct it if required and also specify whether you want to plot chart of data series in rows or columns.

  • Click ”Next” button of dialog box ,Chart options dialog box appears.

  • Specify chart title, X-axis title Y-axis title, legends, Data-labels etc. Click” Next” button.

  • Specify chart location in dialog box. The chart can be created in different sheet. By default, the chart is inserted into the same worksheet.

  • Click the “Finish” button of chart location dialog box to complete the chart creating process.

sumber http://www.computerfreetips.com/Office_Tips/spacing_office.html

Artikel Menarik Lainnya


0 komentar:

 


  © Blogger template 'ASIK-For You' by uc1n.com Blog For uc1n-klik Blog untuk Artikel komputer dan artikel Yang di cari 2012

Blog seputar artikel komputer dan kehidupan sehari hari yang menyuguhkan informasi yang menarik upodate dicari