Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have developed a chart from a set of values of excel file, Now what I have to do that I have to expand the y axis values from point 5 to point 8, Can anyone please suggest me that how to do that.

I have chart of following type.

enter image description here

Reason behind doing so is that, the values between 5 to 8 are not clearly distinguishable. Thanks in advance.

share|improve this question

migrated from stackoverflow.com Aug 5 '13 at 13:33

This question came from our site for professional and enthusiast programmers.

    
down voters kindly dare to put your comments. –  user2320537 Aug 5 '13 at 11:01
1  
Doing what you're asking is a bad idea for column/bar charts. These chart types should always begin with 0, because you're comparing the total length of the value, not the relative difference between end points of the line. Read more about it at Jon Peltier's excellent blog: peltiertech.com/WordPress/…. You could consider alternative graphic presentations like small-multiples/lattice charts, or normalizing the values to allow for more discrete comparisons. –  dav Aug 6 '13 at 16:51

1 Answer 1

Make changes to the scales of value axes

  1. On a chart sheet or in an embedded chart, click the value (y) axis that you want to change.

  2. On the Format menu, click Selected Axis.

  3. On the Scale tab, change the number at which the value (y) axis starts and ends, type a different number in the Minimum box.

Reference: https://office.microsoft.com/en-ca/excel-help/change-chart-axes-HP003065679.aspx#BMchangevalueaxes

share|improve this answer
    
While the answer is technically correct, remember just because you can change the minimum axis, doesn't mean you should change it. –  dav Aug 6 '13 at 16:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.