How to creating chart

Creating Charts 

 You can create a chart on its own sheet or as an embedded object on a worksheet. 
To create a chart, you must first enter the data for the chart on the worksheet, then select the cells and use the Chart Wizard

Try This  

 1. Select the type of chart you wish to create using the Chart Wizard. You can preview how the chart will look by moving the mouse pointer to the Press and Hold to View Sample button.   

2. Click Next and continue with the wizard. You will see the Data Range tab displayed on step 2 of 4. Excel should automatically detect how your series is laid out, however, you can change this if it determines incorrectly by clicking the radio button for the Series in: option yourself. 

3. If you click on the Series tab, you’ll be given the opportunity to change some of the labels used, or pull them from another place on the spreadsheet. 

 4. By clicking Next, you move on Step 3 where you may make other changes to your chart through the use of various tabs. 

5. Clicking Next again will give you the final step, the option to choose where the chart is placed:
• As New Sheet: (Give the Sheet a Name)
• As Object In: Select Sheet

This is an example of a chart that was created as an object in the open sheet following the steps above.

What is AutoCalculate Function

AutoCalculate 

If you need to find a quick total, but you don’t want or need to include that total in the worksheet, you can use the AutoCalculate feature. For example, you may want to sum a list and then use that sum in a formula. You could grab a calculator and add up the figures using the calculator, or you can use Excel’s AutoCalculate feature!

Try This

1.       Select the range you want to perform addition on. The AutoCalculate button in the status bar automatically displays the sum of the selected range.

 

  status bar  

2. Right-click on the status bar area where the sum is displayed and you will be given other AutoCalculate choices. 

3. The result of the function you selected appears in the status bar. If you select additional ranges, Excel uses the most recent function you selected on the AutoCalculate button.  

AutoSum  

The SUM function totals the numeric value of all cells in the range(s) it references. The AutoSum button appears on the Standard toolbar. You can use it to sum adjacent columns or rows automatically. In addition to entering the SUM function automatically, the AutoSum button selects the cells in the column above or in the row to the left of the current cell.

 

Try This  Example

1. Select a cell below or to the right of the values you want to sum.  

2. Click the AutoSum button on the Standard toolbar.  

3. To accept the formula that AutoSum supplies, press Enter. Or, if the formula is incorrect, select a different range to sum and then press Enter. 

Fill Data within a Row or Column  

1. Select the cells you want to copy.  

2. Drag the fill handle across the cells you want to fill, and then release the mouse button. (The fill handle is the small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) 

3. To fill in the active cell with the contents of the cell above it (fill downward), press CTRL+D. To fill in with contents of the cell to the left (fill to the right), press CTRL+R