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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I automate the minimum and maximum x scale?
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? |
Reply |
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) |