Metropol

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

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.

Excellent - thanks for that.