Excel chart, set a vertical baseline on a certain date
 

Hello,

I'v got an excel chart with horizontal the dates and vertical the
values.

I need to set a baseline on a certain date (based on a specific
datafield in the sheet) which is a vertical line on that date from the
lowest value (that is the horizontal line which is zero) to the
maximumvalue in the list.

In the chart you can see then the graph from the first date to the
latest date and the progress related to the values.
On the certain date you see the vertical line which shows the date
were the progress has reached this line.

How can I create this ?????

If not possible to explain this in words, please send me an example.
Thanks !!!

regards,
Johan.

Hello Johan,

I think i understand your desired chart.

See if this helps.

How-to Show Decades and Highlight a Year in the Horizontal Axis
http://www.exceldashboardtemplates.c...r-in-the-axis/

Let me know if it is what you are looking for.

Steve=True