View original (French)

Graphic scale / extreme values

Swimmerseb -  
 Swimmerseb -
Hello,

In a nutshell, I have a histogram with two extreme values, 1550 and 1500, and the rest of the values are between 0 and 20. I would like to interrupt the scale of the vertical axis at 25, so that there is a gap, and then have it continue from 1490 to 1600.

The goal is to see the differences between the small values without removing the extremes from the display.
I should mention that the logarithmic scale does not interest me, and I need to keep the untransformed values.

Is this possible in Excel 2007? If anyone has solutions using other software (Illustrator, etc.), I am also interested!

A big thank you to anyone who has an answer to the question.
Configuration: Windows XP Firefox 3.0

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Good evening,
    just in case, attached is a proposal taken from an English-speaking site XL but for ... XL<2007

    maybe it's adaptable!

    Michel
    3
    1. m@rina Posted messages 27617 Registration date   Status Moderator Last intervention   11 563
       
      Hello Michel ;)

      This is all very interesting but... uh... where is the attachment??? ;)

      m@rina
      0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    here's the link!
    https://andypope.info/charts/brokencolumn.htm

    Have a nice day and thank you
    Michel
    1
    1. Swimmerseb
       
      Hello Michel,

      Thank you very much for your information, it's exactly what I wanted to do!

      I admit that the solution is a bit convoluted to implement on a large number of graphs, but it seems to be the only clean and effective one!

      Thanks again and have a great day!
      0