R
Rob Owen
I wish to show a line graph that increases as it extends to see how actual
perfomance is against projected. I am doing this in access rather than excel,
does anyone know if there is simply something i can tick somewhere that makes
this happen ? What i mean by this is that if I have three months, Jan. Feb
and March and I project a sell of say 10 apples a month and have a line that
rises 10, 20 and then 30 as a projection, how do I make the other line
increase so that if I sold 7, 8 and 11 apples over the months then in March
it would say 26 ? (i realise in a spreadsheet this is easy, by using a
formula, but is there simply something i can tick that makes the y values
accumulate ? Thanks Rob
perfomance is against projected. I am doing this in access rather than excel,
does anyone know if there is simply something i can tick somewhere that makes
this happen ? What i mean by this is that if I have three months, Jan. Feb
and March and I project a sell of say 10 apples a month and have a line that
rises 10, 20 and then 30 as a projection, how do I make the other line
increase so that if I sold 7, 8 and 11 apples over the months then in March
it would say 26 ? (i realise in a spreadsheet this is easy, by using a
formula, but is there simply something i can tick that makes the y values
accumulate ? Thanks Rob