How do make a line correspond to date
 

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

How do make a line correspond to date
 

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical (trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to 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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical (trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to date
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical (trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to date
 

Okay, I have the line, but now I am having trouble getting it straight by date.
--
DMM


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical (trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to date
 

Did you change it to an XY type? Not a line type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
Okay, I have the line, but now I am having trouble getting it straight by
date.
--
DMM


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical
(trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to 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.
--
DMM


"Jon Peltier" wrote:

Did you change it to an XY type? Not a line type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
Okay, I have the line, but now I am having trouble getting it straight by
date.
--
DMM


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a chart with horizontal bars and I want to put a vertical
(trend)
date
line that corresponds to today's date.
--
DMM

How do make a line correspond to date
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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.
--
DMM


"Jon Peltier" wrote:

Did you change it to an XY type? Not a line type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
Okay, I have the line, but now I am having trouble getting it straight
by
date.
--
DMM


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
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


"Jon Peltier" wrote:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in
message
...
I have a chart with horizontal bars and I want to put a vertical
(trend)
date
line that corresponds to today's date.
--
DMM