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

[Tung_Nguyen123]

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?

[grazitti_sapna]

Hi @Tung_Nguyen123 , is this what you are trying to achieve? If not kindly provide with a desired output.

Thanks.

[Tung_Nguyen123]

Hi @grazitti_sapna 

The desired output is as follows:

I want to use stack bar mode for Total operating expenses (include: overhead expenses, Selling expenses, G&A expenses) only.

[grazitti_sapna]

@Tung_Nguyen123 , try now.

Thanks.

[Tung_Nguyen123]

Hi @grazitti_sapna 

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

[grazitti_sapna]

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.