Hello again

I have excel 2007

I have a horizontal bar chart with about 12 bars. The horizontal axis shows
the date; dates range from about 10 days ago to about 3 weeks into the
future.

To set the date axis I have to use 'format axis / options, fixed' & set the
maximum & minimum 'manually'. I would like to set the minimum & maximum
automatically from values I set in cells in the spreadsheet.

Is this possible, ? Can anyone tell me how to do it please ?

Thanks

KK