• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Histogram Like Line in charts [SOLVED]


New Member

I am trying to understand if it is possible to get in excel 2010 a graph that looks like the one in the picture attached. I mean the red line which changes and acts like a histogram, altough it is not a histogram. With each new value the line "jumps" up/down to the next one which it maintains until the new value. The image file was not made in excel so I can't upload an excel file.


OK so far I have a scatter plot with lines connecting, but I can't get the lines that connect the dots to do that effect so far.

Any ideas on how to do it?
Can you post your file ?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
OK I made up a file just for the example itself as the original one contains confidential data.

Column A is Y Axis and column B is X Axis. X Axis is supposed to be the red line in the Picture I uploaded before, the line that I actually need to be formated.



I added two helper columns

Have a look at: https://www.dropbox.com/s/8be2nucuaxu71oy/Red%20Line%20Chart.xlsx
Thats exactly what I wanted!!!!

So I guess the trick to it was using this OFFSET function?

Thank You!!!

There are a number of ways to achieve the extra points, but offset is easy and very transparent in terms of explaining it to someone

The neat part is using the Mod() function to determine if it is the offset row or the next
Very interesting solution Hui.. Loved how using OFFSET you are able to generate all the numbers.

Here is another solution using error bars.



How do you dare to use volatile formulas? Do you want your names blood carved in the wall of the heretics?

... If one guy I know read you...

... And if he ventures to go on evangelizing on the subject... (in this topic, of course)


I use offset all the time in teaching Excel

It is clear and transparent in it's usage as opposed to Index which I use in production systems

Any function will become troublesome when you copy it to a 200,000 row x 200 column range

No function will stress even the weakest PC when only used/copied 30 times