Forum Discussion
stacked Column with different Series type
Hi,
I need to compare the three product lines - A, B, and C and the segments within each product line on the same graph. The data is in the format:
A - 100
A.a. - 30
A.b. - 40
A.c. - 20
A.d. - 10
B - 50
B.a. - 30
B.b. - 20
C -40
C.a. - 15
C.b. - 5
C.c. - 20
I tried using combination graph to represent A,B, C with lines as secondary axis and 100% stacked column to represent A.a, A.b,.... C.c and all however there are two issues - a. the sub products are not the same within three product lines and b. the names for the sub products are not the same for the three product lines. Any help?
1 Reply
Not sure what you mean by "need to compare three product lines". You talk about a line for A, B and C and a stacked column for the segments. How would you like your graph to look like? Could you upload a sketch?
