Possible to automatically have "tighter" X and Y-axis bounds in a simple line chart?

I frequently create a line chart where the X-axis is date/time (just showing time) and the Y axis is a number. Whenever Excel generates the chart, it leaves a fair amount of space on the left and right sides of the chart, before the earliest time/date and after the latest time/date, where there is no data. I'd like the chart to be "tighter," so that the leftmost data point is very close to the Y axis on the left side, and likewise the rightmost data point is very close to the Y axis on the right side. For a time/date X axis, this is particularly cumbersome to implement, because Excel shows those bounds as long, floating point numbers, rather than actual dates and times. I end up having to use trial and error every time to pull in the left and right sides of the chart, increasing the minimum and decreasing the maximum by .001 until it looks right. Is there an easier or, ideally, automated, way to accomplish this?

I have a similar goal for the Y axis, although this is easier to do manually, since the Y axis is charting numbers, so I can just manually enter in the lowest and highest number to bring the chart in that way.

I'd be open to a VBA recipe if that's the only way as well.

Thanks, your linked script worked for me. Here's what I ended up with, which is idiosyncratic to my application but perhaps useful as an example for others:

Please Login or Register  to view this content.

What this does:

• Selects the active worksheet
• Selects the first chart on the active worksheet
• Selects the data source for the chart, starting on row 48, continuing until the last row that has data, using columns A-C
• Moves the chart to the top left position on the active worksheet
• Sets the X-axis range on the chart to match the range of values in column A (row 48 through the last row)
• Sets the Y-axis range on the chart to match the range of values in column B (row 48 through the last row)
• Rounds the Y-axis values down by 5 for the minimum and up by 5 for the maximum
• Sets the worksheet zoom level to 86

Then I added a hotkey and a quick access icon to invoke this macro.