Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
Your question is not very clear in what you see right now and what you expect (which results in answers that don't fit with your expectation, as you already noticed). Could you provide a sample of your data or a picture of what you have right now? – agtoever Jan 4 '15 at 17:36

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .