lyp_sj


Hello,

I'm trying to make a chart with below data table. What I need is to show primary x-axis as years(2005, 2006, 2007, 2008). And in each year, I want to build bars by seasons(Vday, Easter, Halloween, Xmas). In each bar, I want to breakdown by Brand( skittles, starbust, jelly beans). How can I do that Thanks so much!

Basically, I could not breakdown each bar with brand information.

B.regards/Yaping

Brand Season 2005 2006 2007 2008
Skittles Vday $ 2.37 $ 2.82 $ 2.00 $ 1.93
Starburst Vday $ 2.09 $ 0.27 $ 0.36 $ 0.29
Jelly Beans Vday $ - $ - $ - $ -
Skittles Easter $ 5.60 $ 4.33 $ 4.55 $ 4.48
Starburst Easter $ 3.27 $ 3.25 $ 3.42 $ 4.87
Jelly Beans Easter $ 17.95 $ 16.57 $ 17.60 $ 17.88
Skittles Halloween $ 14.40 $ 16.22 $ 21.32 $ -
Starburst Halloween $ 15.08 $ 15.07 $ 18.57 $ -
Jelly Beans Halloween $ - $ - $ - $ -
Skittles Xmas $ - $ - $ 1.56 $ -
Starburst Xmas $ 3.58 $ 1.91 $ 4.22 $ -
Jelly Beans Xmas $ - $ - $ -





Re: How can I make a chart with 2 x-axis categories?

Andy Pope


Hi,

You need to change the layout of your data.



2005 2006 2007 2008
Vday Easter Halloween Xmas Vday Easter Halloween Xmas Vday Easter Halloween Xmas Vday Easter Halloween Xmas
Skittles 2.37 5.60 14.40 - 2.82 4.33 16.22 - 2.00 4.55 21.32 1.56 1.93 4.48 - -
Starburst 2.09 3.27 15.08 3.58 0.27 3.25 15.07 1.91 0.36 3.42 18.57 4.22 0.29 4.87 - -
Jelly Beans - 17.95 - - - 16.57 - - - 17.60 - - - 17.88 - -