Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Subtraction

advanced excel seminar training - Subtraction

ResolvedVersion Standard

Tue 8 May 2007, 14:08 Delegate Elizabeth said...

Elizabeth has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Subtraction

How do a apply a formula to allow subtraction between columns in a chart

Wed 9 May 2007, 15:03 Trainer Tracy said...

RE: Subtraction

Hi Elizabeth,

Thanks for using the forum.

What you can do is put in different cells

A1 = 100
B1 = 45
C1 = A1 - B1

and you can plot a graph using the series A1:C1 so you can see the values in the first two bars and the last bar will be the formula of the first two.

I hope that answers your question, if not let me know

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

advanced excel seminar training - Subtraction

Subtraction

RE: Subtraction

Excel articles

Excel tip:

Entering text in Multiple Worksheets