To copy the formula, highlight the cell containing the formula and use the menu Edit-Copy. Select the cell that you want to copy the formula to and use the menu Edit-Paste. When used in a formula, a relative cell reference denotes the cell used in the calculation by location in relation to the cell being modified. This concept can get a bit confusing. You can see a demonstration which may provide clarity.
Most charts can be quickly and easily created using the chart wizard.
Invoke the chart wizard by clicking on the button in the standard toolbar. Let's take a look at an example of the chart wizard in action. Let's say that we have 5 months worth of sales figures from three different divisions of a company. First, we would invoke the chart wizard by clicking on the button in the standard toolbar. The first step in creating any chart is to define which type of chart you want to create.