How do make a line correspond to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart with horizontal bars and I want to put a vertical (trend) date
line that corresponds to today's date.
 
Hi Jon,

I appreciate the input, but I may be doing somehting wrong because I keep
getting another horizontal line. Below is a sample of what I'm trying to do.


92215------value---value----------------value
92364--value------------------------value------------value
78952------------------value--value--value------value

5/1 5/31 6/1 6/30 7/1 7/31 8/1 8/31

If you can imagine the Y axis is a text and the values whole numbers. The X
axis are dates (formulated).

When I try to run your program, I am getting a bar at the end of each line.
I'm sure I'm doing one little thing wrong, but I can't find it.

DMM
 
The bar might just be the series being added. You need to select the bar, go
to Chart menu > Chart Type, and change it to an XY type. The article should
help with the rest of the procedure.

- Jon
 
Yes, I did. I think the problem is with my data

05/24/06 0
05/24/06 0
05/24/06 0

I would like the line to move with today's date. I know it's some really
stupid I'm doing. Thanks for all your help thus far.
 
Well, today is 05/24/07, so you may be off by 365 days :-)

You could simply put =TODAY() into the cells, and they'll update whenever
you open the file.

- Jon
 
Back
Top