# Integer tick mark values not set by the decimal axis minimum value.

#### Ceywood

##### New Member
Hi everyone,

sorry I think this must be a really simple thing to sort out but for the life of me I can't seem to figure out how to do it (or word the question accurately enough to get a good response from Google!):

I've got a pretty simple xy scatter graph with two Y-axes. On the primary Y-axis is pH (graphs for a chemistry thesis) and with all of these graphs (I will need to generate hundreds, all with the same set of axes but different data) the minimum and maximum axis values are decimals (eg 2.871 - 11.085) because the axis needs to exactly encompass the data. However, by setting these irregular values for axis minimum and maximum, my major unit tick marks are also decimals (2.9, 3.9, 4.9 etc to 10.9). Is there a way to have decimal values for the minimum and maximum but then set the tick marks from a different value as integers (ie so they'll show up at 3, 4, 5 etc to 11)?

I have found a good potential solution at the link below, but it involves multiple extra steps which is a lot when having to apply to hundreds of plots when it seems as though this should be a feature of excel...?

Arbitrary Axis Scale

Thanks for the help

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Replies
0
Views
241
Replies
0
Views
4K
Replies
1
Views
300
Replies
2
Views
883
Replies
1
Views
4K

1,195,953
Messages
6,012,518
Members
441,704
Latest member
Perez1

### 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