I have a table like this
----------------------------------------------------------------------------------------
2010 Sales in chocolate Sales in sweet
A shop B shop Total A shop B shop Total
Jan 4 0 4 0 0 0
Feb 4 0 4 2 0 2
Mar 0 0 0 5 0 5
Apr 8 0 8 2 0 2
May 3 0 3 1 1 2
Jun 5 0 5 4 0 4
Jul 7 0 7 2 1 3
Aug 4 1 5 2 0 2
Sep 1 1 2 4 0 4
Oct 3 0 3 0 0 0
Nov 1 1 2 2 0 2
Dec 4 0 4 1 1 2
Total 44 3 47 25 3 28
----------------------------------------------------------------
I would like to create a skated column chart with sales in chocolate in one column with 2 colours for shop A and shop B, and one similiar column for sales in sweet for shop A and shop B for each month. How can I do this ??
Thx for your help ~~~.~
Bookmarks