Office 2021: How to create grouped bar chart of three columns?

I couldn’t figure out how to create grouped bar chart of three columns to get a chart as per the screenshot below

The data is attached

Attached Images

Clip_154.jpg (184.5 KB, 21 views)

Attached Files

GWR-XGBoost_Comparison.xlsx (10.4 KB, 6 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

This should set you on track

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

In the attached there's a load of trial and error nonsense on sheets Sheet1 to Sheet5. I've left them there only in case they might be of interest.

I eventually succeeded in getting close to what you want in the sheet called Look.
On this sheet, the topmost chart is the result of simply selecting the whole of the green table and inserting a 2D column chart.
The lower chart is the same thing tweaked a bit.

2024-02-15_001327.jpg

You could rearrange the data as in the top left green table in the Look sheet manually, but it's hard work, so in fact this table is the result of a transformation by Power Query of your data on Sheet1 cells A1:C10, which I've made into a proper Excel Table called Table1 and this is what Power Query starts with. You can see the bottom right extent of the table as a little symbol in the bottom right corner of cell C10. You can drag this symbol to change the size of the table, although you'll probably not need to.
So as long as all your data is within that table, Power Query will transform it to the green table at the top left of the Look sheet. You'll need to refresh the query if you adjust the data on Sheet1 which can be done by right-clicking the green table on the Look sheet and choosing Refresh.
The source table on Sheet1 should retain its headers just as they are - the query uses them.

The final sheet, Sheet6, is the result of following (most of) the instructions in Pecoflyer's link. This is very similar but I can't easily change the colours as you'd like them, nor can I get the correct legend easily.

Attached Files

msofficeforums52067GWR-XGBoost_Comparison.xlsx (82.8 KB, 3 views)

Thank you guys for the help. I got an advice just rearrange the structure of the data in order to get the chart output i need as per the following screenshots:

Attached Images

	Clip_798.jpg (169.5 KB, 13 views)
	Clip_799.jpg (137.7 KB, 12 views)
	Clip_800.jpg (142.3 KB, 12 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

screenshot cont.

Attached Images

	Clip_801.jpg (243.9 KB, 12 views)
	Clip_802.jpg (237.2 KB, 12 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

Well…
1. That's not what you asked for.
2. I did mention that rearranging the data could be hard work, but more than that, it has to be done correctly. You have managed to reverse the values for XGBoost Ye and Fan:



2024-02-16_112714.jpg


Consequently this is wrong:


2024-02-16_112820.jpg


It's better to do that sort of transformation automatically, especially if there's more data to rearrange.

Thank you very much p45cal for the prompt help. This is very useful. I have adapted my chart based on your correction

Attached Images

	Clip_811.jpg (150.5 KB, 11 views)
	Clip_812.jpg (217.1 KB, 12 views)
	Clip_813.jpg (214.4 KB, 12 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.