Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maximum/minimum value in formula | Excel Discussion (Misc queries) | |||
graphics scale minimum | New Users to Excel | |||
Spinners - minimum and maximum | Excel Discussion (Misc queries) | |||
Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
Minimum and Maximum with Complex Criteria | Excel Discussion (Misc queries) |