#1
|
|||
|
|||
Office 2021: How to create grouped bar chart of three columns?
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#3
|
||||
|
||||
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. |
#4
|
|||
|
|||
Quote:
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:
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#5
|
|||
|
|||
screenshot cont.
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#6
|
||||
|
||||
Quote:
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. |
#7
|
|||
|
|||
Thank you very much p45cal for the prompt help. This is very useful. I have adapted my chart based on your correction
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to disconnect Onedrive from Office 2021 | Randall49 | Office | 0 | 04-07-2023 09:08 AM |
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? | leeuniverse | Excel | 2 | 03-30-2023 11:00 PM |
Transition from Office 365 to Office Pro 2021 | PHearn | Outlook | 0 | 06-08-2022 07:01 PM |
Can't can't install new office professional plus 2021 | ottiliegirl | Office | 4 | 05-31-2022 03:14 PM |
Office 2021 for Mac | NeilC | Office | 3 | 10-14-2021 01:50 AM |