How do I automate the minimum and maximum x scale?

[Jgraves]

I have an xy scatter plot with a date/time on the x axis (range). The date
in the range updates to the current day. I have the x minimum and maximum
values in my graph set to span an exact 24 hour periord.

When I use the "Auto" feature, it puts a large gap on either side of the
selected data. I am trying to get rid of these gaps by manually setting the
min/max on the x axis scale to the exact 24 hour period I am graphing.

When the date rolls to the next day, the min/max values that I set manually
do not change and remain set for the previous day. Is there any way to have
the min/max values automatically adjust to the current day, or to look at the
date in my data array?

 

[Jon Peltier]

You could write formulas to determine useful axis limits, then use VBA to
apply them:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

- Jon