how to get the Y Axis to cross at "Today's Date" i

[cathyo]

I'm sorry - I'm under a time constraint and didn't spend much time searching for an answer...thus, I could use help as soon as possible.

I'm creating a chart where the X axis are dates, everyday -- past 3 weeks months as well as the next 3 weeks. The data plotted to the left of "today" is actual data, whereas the data plotted to the right is estimated data.

I create a vertical line on the graph to indicate where "today" is (double click on X axis, format axis window appears, go to scale index and change the date in the "Value (Y) axis crosses at"

I added a button with a macro assigned to it that will refresh the data and update the chart -- I recorded a macro that changes the date but the code shows "09/28/2006" in the code and I'd like to change the code so it's enters today's date. Can anyone help? Thank You!

 

[Jon Peltier]

    With ActiveChart.Axes(xlCategory)
        .CrossesAt = Now
    End With

 

[cathyo]

I can't believe it's that easy! Thank you so much!