I am having troubles in merging two different chart types of Excel into one.
More specifically:
For each point in time (4 months in total) I have two sets of data (A and B). For Jan, Feb and Mar I want to display A and B as clustured columns (i.e. one column for A and one for B close to each other). On the last observation (Apr) I do not want to show A and B but rather their sub-components (in the case of A, I want to display Z and Y in a way that Z+Y=A). This subcomponents should be displayed as stacked column (one column with the two sub-components). The same applies for the last observation of B.
Does someone know how to do it?
More specifically:
For each point in time (4 months in total) I have two sets of data (A and B). For Jan, Feb and Mar I want to display A and B as clustured columns (i.e. one column for A and one for B close to each other). On the last observation (Apr) I do not want to show A and B but rather their sub-components (in the case of A, I want to display Z and Y in a way that Z+Y=A). This subcomponents should be displayed as stacked column (one column with the two sub-components). The same applies for the last observation of B.
Does someone know how to do it?