I am using a bar graph to display a list of projects
where each project has a start date and an end date. The
chart is set up for a 3 year time frame with the projects
listed on the left side of the chart from top to bottom,
months go from left to right across the top of the chart.

What I need to do is have a vertical "time line" for the
current date to show on the chart.

An help on how I can set this up is greatly appreciated.

Thank you,
Gail

Hi Gail -

Try one of the methods described here:

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

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

Gail wrote:

> I am using a bar graph to display a list of projects
> where each project has a start date and an end date. The
> chart is set up for a 3 year time frame with the projects
> listed on the left side of the chart from top to bottom,
> months go from left to right across the top of the chart.
>
> What I need to do is have a vertical "time line" for the
> current date to show on the chart.
>
> An help on how I can set this up is greatly appreciated.
>
> Thank you,
> Gail
>
>
>
>