Manually Setting Date/Time Range of Axis
I have an XY chart that takes data from two columns. The 1st column is a
production amount (in cubic yards), while the second is the corresponding date/time. The data is plotted as expected (x = date/time, y = production). The workbook is automatically opened on a shift basis, to generate a shift report. As such, the data in the columns that the chart is looking at changes each time it is run. The problem with this is the time range on the x axis is not maximized for the date/time range in the column (i.e.: it shows a larger range than required). I would like to manually set the range of the x axis to maximize the viewable area of the chart, but it looks like Excel represents this in some floating point format. Is there anyway I can prorammatically change the range of a chart to accommodate this requirement? Thanks! |
The following article was written with a line chart in mind, but the
same approach can be used with an XY chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ pittpanther wrote: I have an XY chart that takes data from two columns. The 1st column is a production amount (in cubic yards), while the second is the corresponding date/time. The data is plotted as expected (x = date/time, y = production). The workbook is automatically opened on a shift basis, to generate a shift report. As such, the data in the columns that the chart is looking at changes each time it is run. The problem with this is the time range on the x axis is not maximized for the date/time range in the column (i.e.: it shows a larger range than required). I would like to manually set the range of the x axis to maximize the viewable area of the chart, but it looks like Excel represents this in some floating point format. Is there anyway I can prorammatically change the range of a chart to accommodate this requirement? Thanks! |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com