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.

Is it possible to make a graph with vertical exaggeration?

I am trying to plot several graphs (normalized), but in the Y scale I only can see some little bumps.

share|improve this question

3 Answers 3

Manually set the y-axis limits in the graph properties dialog.

share|improve this answer
    
I tried your recommendation, but t didnt work, my graphs are totally flat. I am trying to plot several graphs (normalized), but in the Y scale I only can see some little bumps. –  Joey Jul 14 '11 at 1:23
1  
This should work, in Excel 2003, right-click on the Y-axis, select Format Axis..., click on the Scale tab, set the minumum and maximum to the min and max Y values for your data. –  Hydaral Jul 14 '11 at 2:34

Sometimes extreme values will make the rest of the data look like very small bumps in a graph. Remove these values, which sometimes are categorized as outliers, and re-plot everything, this should fix the problem.

share|improve this answer

Go to the properties dialog for the y-axis and select Logarithmic.

share|improve this answer
    
This does not exaggerate, it un-exaggerates. –  Hydaral Jul 14 '11 at 2:29
1  
@nnewton, yes I agree but the question is pretty vague. If the OP's data is mainly small values with a few very large values then Excel's auto-scaling will make the small values fairly indistinguishable from each other ("little bumps"). Logarithmic mode will help spread them out. –  Mike Fitzpatrick Jul 14 '11 at 23:11

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.