Using source data from an Excel sheet I have created a bar chart on the same
spreadsheet that goes across horizontally. The data is just start and finish
dates of jobs. Some jobs have started and finished. Some have started and are
yet to finish.

Along the Value Axis along the top there are a series of datesset a week
apart. I would like to pu a line or arrow along this value access that show
he current date whenevr this spread sheet is opened

Look here for information about adding lines to your charts:

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

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

Rizla wrote:

Using source data from an Excel sheet I have created a bar chart on the same
spreadsheet that goes across horizontally. The data is just start and finish
dates of jobs. Some jobs have started and finished. Some have started and are
yet to finish.

Along the Value Axis along the top there are a series of datesset a week
apart. I would like to pu a line or arrow along this value access that show
he current date whenevr this spread sheet is opened