Hello,

I'm creating a horizontal bar chart. The horizontal axis is a date, and I
want the minimum of the axis to be todays date TODAY() , and the maximum to
be 30 days ahead.

I know how to do this manually, by enterinng the dates via the 'scale'
minimum & maximum tabs, but can it be done automatically ?


I have Excel 2000

Thanks

KK