Excel chart that has min/max values based on cell data

I am trying to build a chart that has the x/y min/max values tied directly to cell values. I located code that will allow this, but I am having difficulties applying it and placing it correctly.

My desire to have hours (and date due to capability to handle the values when it crosses a date), but I want the hours in even hours (ie 0100, 1500, etc). I can get the worksheet to calculate the values that I want for min/max, but I don't even know how to begin to get that spread into an interval that equate to even hours on the axis.

I don't even know if want I want to accomplish is possible, but I have attached my work in progress that explains what I am trying to complete. I think that my cell notes explain what the values are....

Thanks for all of the help!
Buster

This will update the chart, except for the MajorUnits as these are currently not calculated

Please Login or Register  to view this content.

Andy,

That works great! Thanks for the help...

I figured out a way for it to calculate the major units with date/time, probably did it a longer/harder way than it had to be done.... but it does what I want it to do! At least at this stage...

Buster