# Set chart's Y-axis min. to AUTOMATICALLY graph lowest value

#### JaredSorensen

##### Board Regular
I want to create a dynamic graph that not only uses a dynamic max value for the Y-axis, but also a dynamic min value that is NOT ALWAYS zero.

Imagine a graph that displays sales for last 5 days. If the max was \$24,578 and the min was \$15,697, then I'd want the chart to show a lower bound of \$15,000 and an upper bound of \$25,000. But if the next week the max was \$30,209 and the min was \$27,810, then I'd want chart lines from about \$27,000 to \$31,000. The problem is that if I have the "Auto minimum" checked on the Y-axis, then it always gives me a lower bound of 0--all of which empty space I would prefer to eliminate.

The solution may have something to do with the Format Axis > "Category (X) axis Crosses at: " but I have been unsuccessful even as I tried every combination. One graph I have seen from a colleague, that successfully does what I want to replicate, has the "Auto" column checkmarked for both "Minimum" and "Category (X) axis crosses at:" but the trick is that it displays the same (non-zero) value in the "Minimum" textbox and "Category (X) crosses at:" textbox--and that value changes if the minimum value in the graphing series changes.

Any help would be very welcome! Thanks.

Jared

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,960
Messages
5,856,525
Members
431,820
Latest member
Tori Murphy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back