View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jgraves jgraves is offline
external usenet poster
 
Posts: 10
Default How do I automate the minimum and maximum x scale?

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?