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?

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jgraves" wrote in message
...
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?