# Can't change the maximum value on the x axis...

#### chimpsky82

##### New Member
Hi all

I've just produced a chart with bins 1, 1.5, ... , 6, comprising 11 values in total. When I create a chart Excel 2007 puts the values 1-11 on the x-axis. I've read in various places (e.g.http://www.dummies.com/how-to/conten...007-chart.html) that going into Format Axis > Axis Options should give one the opportunity to specify the max (and min) values etc. However, the window I get simply doesn't offer this option . Instead I just get:

Interval between tick marks
Interval between labels
Catgories in reverse order
Label distance from axis
Axis Type

Major tick mark type
Minor tick mark type
Axis labels

Vertical axis crosses
Position Axis

Cheers

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### iyyi

##### Active Member
Try to change the chart type to Scatter Chart

#### chimpsky82

##### New Member
Thanks very much iyyi. That does work: Minimum and Maximum now become available and actually Excel for some reason doesn't convert 1-6 into 1-11, but leaves it at 1-6 (well, the scale goes up to 7 but that can subsequently be adjusted). The trouble, unfortunately, is that for the purposes of the presentation I have to give (on some research in psycholinguistics) bar charts are really the way to go. I would have thought that these options ought to be available for all kinds of charts... they are in this video: How to Make Histogram on Excel 2007 - YouTube

Confusing!

Replies
0
Views
2K
Replies
5
Views
276
Replies
2
Views
2K
Replies
0
Views
406
Replies
6
Views
869

1,181,848
Messages
5,932,442
Members
436,838
Latest member
rparthireddy

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