I think a sample file which includes some of those failed attempts would be helpful for us to understand what you want.

I expect that the difficulty is how to "hide" the 0 values in the chart. Have you tried using N/A for those values? I would expect that to work just fine. See this discussion on simulating empty cells in charts: http://peltiertech.com/mind-the-gap-...g-empty-cells/