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

chimpsky82

New Member
Joined
Jan 26, 2013
Messages
3
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 :confused:. 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

I'd be very helpful for advice on what I'm doing wrong...

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

chimpsky82

New Member
Joined
Jan 26, 2013
Messages
3
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! :confused:
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top