Different bar mode (group for Revenue and stack for Total operating costs, etc)

Question

Hi all,

I have a data set in the attached file.

I want to create a bar chart for all columns in the data set (Revenue, Total operating expenses).

However, for bar chart of Total operating expenses. I want to create a stack bar chart for its breakdown (Cost of sales, Selling expenses, G&A expenses).

Can anyone have any idea?

sample data.xlsx

grazitti_sapna · Answer

Hi @Tung_Nguyen123 , according to me I do not think that it is possible as one of the bar char is stacked and other is normal. what can be done is to create two separate charts and union them, as what I did in the workflow.

Thanks.

Tung_Nguyen123 · Answer

Hi @grazitti_sapna

Is there a possible way to have 2 separate charts in 1 chart only?

grazitti_sapna · Answer

@Tung_Nguyen123 , try now.

Thanks.

BarChart-GS.yxmd