ExcelIsEasy
New Member
- Joined
- Jan 21, 2012
- Messages
- 20
- Platform
- Windows
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?
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
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>