Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Oct 25, 2024

How to set min max bounds for Custom Values

Dear Experts,

                    I have an issue where in Y-Axis , I have time in format h:mm:ss.000, and I need to set min/max according to the data I have (attached)

But, seems in the Axis options, not much can be achieved, please share if it's possible and how.

Thanks in Advance,

Br,

Anupam

excel
Formulas and Functions

9 Replies

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 25, 2024

        anupambit1797 

        Double-click the y-axis.

        In the Format Axis task pane, in the Axis Options tab, expand Number,

        Click in the Format Code box and enter h:mm:ss.000, then click Add.

        The y-axis will now use this format:

        If you want to set the minimum or maximum, calculate the corresponding number:

        • Enter a time value in a cell.
        • Change the number format to General.
        • Copy the value in the Formula bar.
        • Paste it into the Minimum or Maximum box for the y-axis scale.

Resources