Stacked column chart with month on month sales growth

[Snehapbidev]

I have a requirement of plotting sales growth month on month for 2 years categorised by 3 regions (legend) . I am able to plot the chart , however the months columns are displayed year wise like Jan to dec for 2023 and again Jan to April for 2024( bars) . 

I want Jan 2023 and Jan 2024 sales side by side . Similarly for other months. 

How to rearrange in this manner in x axis.

[Anonymous · Accepted solution]

Hi @Snehapbidev ,

First of all, many thanks to @amitchandak  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Drag the month into the X-axis, drag the sales into the Y-axis and drag the Region into the legend.

3.Drag the Year field into the small multiples. Set the Rows is 2 and the Columns is 1.

4.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Snehapbidev for that in your visual first drag month and then year and use concatenate label off and sort on axis

You need to have two columns on axis , month (with a sort column month no) and year

It is default option these days, in case it does work

Concatenate Label off : https://youtu.be/QgI0vIGIOOk