Reputation: 73
I want to plot a chart with 2 columns on same chart and i want it to be grouped by third category "Code" Currently my chart looks like this , Light blue colour represents "FirstSize" and dark blue represents "SecondSize" , x-axis has "Account Name".
However , I want the above graph to group the stacked columns based on the third category "Code" , The below example shows the third category values "M" , FR", "BR" , "D" etc... and then may be use a different color along with these two represent two type of sizes ( stacked )
So , I want to be able to do something like adding a Column Series "Code" in the below settings to make it work.
Is it possible via any visual ?
Upvotes: 0
Views: 2751
Reputation: 16908
You need some transformation in your data to achieve your required output. For say, If I am correct you have now data in this below format-
code firstsize secondsize
code1 10 20
code2 25 30
You have to transform your above data and as below which is basically an un pivot of data-
code size value
code1 firstsize 10
code1 secondsize 20
code2 firstsize 25
code2 secondsize 30
Now you can configure your Stacked Column chart as below to get your desired output.
Code as Axis
Size as Legend
Value as Values
Upvotes: 0