Hi
I am working with Excel and I have a graph that adds a coloum each week.
The target for each week is 5.
How do I put a line on the graph starting at 5 on week one then goes to 10 on week 2 and so on?
Thanks
Excel Help....
-
Joe Public
- Posts: 155
- Joined: Sat 16 Aug, 2003 18.43
In connection with my cr*p spelling I would like to anotate all my posts with (sp?)
You just need to add a column which is plotted on the graph and has a simple formula in it. To be honest you could just type in the numbers as adding 5 each time isn't really worthy of a formula, however...
Put the number 5 in the first week's target column (for example cell B1) then paste =SUM(B1+5) into the columns below for the weeks you require. The spreadsheet will increment the B1 to be B2, B3 etc as you go down the rows.
Put the number 5 in the first week's target column (for example cell B1) then paste =SUM(B1+5) into the columns below for the weeks you require. The spreadsheet will increment the B1 to be B2, B3 etc as you go down the rows.
-
Joe Public
- Posts: 155
- Joined: Sat 16 Aug, 2003 18.43
Excellent - thanks for that.
In connection with my cr*p spelling I would like to anotate all my posts with (sp?)