How to remove blanks in column chart?

[ExcelIsEasy]

I have a little issue with column chart. It's a report which I prepare every 3 months. Since this year my data changed. Rows a and c I got together now. And I don't know what to do with blanks on the chart. Any ideas?


[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]1Q12[/TD]
[TD="width: 64"]2Q12[/TD]
[TD="width: 64"]3Q12[/TD]
[TD="width: 64"]4Q12[/TD]
[TD="width: 64"]1Q13[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]a+c[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]80[/TD]
[/TR]
</tbody>[/TABLE]

 

[ExcelIsEasy]

Anyone helps me how to organize my column chart?

 

[nuked]

Combine A+C on the historical data then remove the original A, and C series from the chart?

If not, I'm not entirely sure what you expect to replace the blanks? - dummy data?

 

[ExcelIsEasy]

I can't combine data. My boss thinks that it would be cheating about hictorical data.

Do you have some idea how to remove these 2 gaps?

 

[ExcelIsEasy]

Anyone?