How to use Today() for X axis crossover point automatically

[Kistelek]

I have a graph with dates across the X access and I want the Y axis to cross at today's date. I can do this manually by Format Axis->Vertical Axis crosses->At date and putting the date in but I'd like Excel to put whatever today's date is in there automatically. Is that easily doable?

 

[C Moore]

Here is an ok explanation of using defined names. Use defined names to automatically update a chart range - Office