How do you create this chart?

[jasonleewkd]

Hi all, the chart looks deceptively easy to create, but I can't seem to do it. Tried things like format axis, gaps between axis, overlaps between charts but to no avail. Any form of help is appreciated!


The link to the chart is here https://docs.google.com/file/d/0BzQyFnW9qIEXanM4Z25oWVU0NVE/edit?usp=sharing

 

[dan_l]

I wonder if that's just clever use of the drawing tool.

 

[keymaster]

You can do this by mixing regular column chart with a line on secondary axis (that has a very large negative minimum) and by hiding negative secondary axis labels.


See attached. Examine the chart format and structure of input data for more.


http://img.chandoo.org/playground/column-line-combo-chart-jason.xlsx

 

[jasonleewkd]

Awesome lifesaver!