Forum Discussion
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...
You attached an empty workbook.
Thanks HansVogelaar , and strange I uploaded the one with 19kb.. let's see this time.
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.
Thanks HansVogelaar , I tried the same, but, as you see the interval 17:07:50.625 (row num: 3, entering state: pugIdleState) is then not shown below need to increase the granularity in Y-axis also ,
Br,
Anupam
