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
 
Okay, I have the line, but now I am having trouble getting it straight by date.
 
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
 
You must log in or register to reply here.

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

Similar Threads

reference line on bar chart 2
Problem adding vertical marker line to line chart 6
Create vertical line to indicate date on chart with series of date 1
How do I add a vertical line to a horizontal bar chart? 3
adding marker points 2
Bar Chart with Secondary Line 1
Vertical alignment in data table? 1
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1

Back
Top