How do make a line correspond to date

S

soconfused

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

soconfused

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
 
J

Jon Peltier

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
 
S

soconfused

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top