Friday, November 25, 2011

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.

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

No comments:

Post a Comment