Chart: Remove whitespace from empty (non-existent) columns

[throwaway992]

In Excel2013, I'm trying to generate a graph from this table.

It turns out like this.

This is almost what I need however there is an unnecessary whitespace for every blank cell. It's more obvious when you look at the ref bars. I suppose Excel is creating a column of height 0 for every blank cell. I really need to change this behaviour and remove those empty columns.


Can somebody help me?

 

[Steve=True]

Hi Throwaway,

Check out this post and video tutorial.

It works for your specific situation.

http://www.exceldashboardtemplates....whitespace-from-empty-or-zero-columns-part-1/

Let me know it helps.

Steve=True