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?

	1Q12	2Q12	3Q12	4Q12	1Q13
a	56	78	97	45
b	4	5	3	5	4
c	20	10	10	20
d	6	3	4	6	2
a+c					80

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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?