vertical line in graph

Hi all,

I have data, let's say

weeknumber cars sold in 2003 (cumulative) cars sold in 2004
(cumulative)
1 0
0
2 2
2
3 3
5
4 6
9
5 10
13
6 12
17
7 16
22
8 19
28
9 21
10 25
11 29
12 33
etc. etc.

This will give a nice graph (line graph, first sub type, so a "normal" line
graph, weeknumbers along the x-axis, cars sold along the y-axis).
Suppose we are now in week 8. This year so far sold 28 cars (don't know if
it is a lousy performance compared to USA standards for car salesmen, this
is just an example).
Now I want in my graph automatically a vertical line originating in the
point on the x-axis that corresponds with this week (8 in this example), so
next week it will automatically shift one place to the right (to 9).
I tried to make that line by adding to the graph a set of data like this

=weeknum(today())+0.001 0
=weeknum(today())+0.002 1
=weeknum(today())+0.003 2
=weeknum(today())+0.004 3
=weeknum(today())+0.005 4
=weeknum(today())+0.006 5
=weeknum(today())+0.007 6
etc. etc.


This line should look vertical, but whatever I do, I always get sloped lines
or a horizontal line that intersects the y-axis at the point that
corresponds with the current weeknumber, so in my above example I get a
horizontal line through y=8 in stead of a vertical one through x=8.

I have the feeling that my whole set up (the =weeknum(today())+0.001
contraption) is stupid anyhow.

Your help will be very much appreciated.

Jack Sons
The Netherlands

Jon Peltier has instructions for adding vertical lines to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine

Jack Sons wrote:
Hi all,

I have data, let's say

weeknumber cars sold in 2003 (cumulative) cars sold in 2004
(cumulative)
1 0
0
2 2
2
3 3
5
4 6
9
5 10
13
6 12
17
7 16
22
8 19
28
9 21
10 25
11 29
12 33
etc. etc.

This will give a nice graph (line graph, first sub type, so a "normal" line
graph, weeknumbers along the x-axis, cars sold along the y-axis).
Suppose we are now in week 8. This year so far sold 28 cars (don't know if
it is a lousy performance compared to USA standards for car salesmen, this
is just an example).
Now I want in my graph automatically a vertical line originating in the
point on the x-axis that corresponds with this week (8 in this example), so
next week it will automatically shift one place to the right (to 9).
I tried to make that line by adding to the graph a set of data like this

=weeknum(today())+0.001 0
=weeknum(today())+0.002 1
=weeknum(today())+0.003 2
=weeknum(today())+0.004 3
=weeknum(today())+0.005 4
=weeknum(today())+0.006 5
=weeknum(today())+0.007 6
etc. etc.


This line should look vertical, but whatever I do, I always get sloped lines
or a horizontal line that intersects the y-axis at the point that
corresponds with the current weeknumber, so in my above example I get a
horizontal line through y=8 in stead of a vertical one through x=8.

I have the feeling that my whole set up (the =weeknum(today())+0.001
contraption) is stupid anyhow.

Your help will be very much appreciated.

Jack Sons
The Netherlands




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html