How do I set a maximum value on the x axis of a graph?

G

Guest

Trying to show people's scores on a test using a bar graph, need to have a
maximum value (maximum score on the test) set on the x axis.
I.e for a person who scored 35 out of a possible maximum mark of 50 the bar
would have to go up to 35 but the scale on the x axis would have to go up to
50.
 
J

Jon Peltier

If it's a bar graph with horizontal bars, the horizontal axis is the Y axis. Double
click on it, and on the Scale tab, adjust the parameters to suit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
How can I make a scatter plot graph with a category x-axis? 0
Formatting 'X' Axis -- 2 fundamental differences 7
Constant % on X axis 2
X Axis to Scale 2
Chart with differing x axis 1
Remove Bar Graph Axis Values 0
I cannot set the maximum date for the axis of a line chart 5

Top