Creating Multiple bar chart to show differences

[Ebele1]

Hi,
I'm quite new to excel and I have been struggling to make a multiple bar chart to show differences in assessment. I tried to create one but it never appeared the way I wanted it. I have attached an excel sheet showing a snippet of the data and a picture of the kind of graph I'm wanting to recreate. Please note the x-axis axis would read Complaint, partially Complaint and Not Complaint (not what it is presently showing) while the y-axis will read No of controls. I will appreciate every help on this. Thank you so much.

[AliGW]

Welcome to the forum.

Select the data > Recommended Charts > insert, then change from bar to column in the chart design tab.

[Ebele1]

Hi AliGW. Thanks for your quick response. I have seen your worked solution. However, rather than just having individual bar charts for complaint, partially complaint and not complaint. I want to have two bar charts side by side for complaint, partially complaint and not complaint. So based on the previously attached image, I want to have the blue bar chart representing the CHAIN ASSESSMENT and the green bar chart ROOT ASSESSMENT for complaint. Then I'll have the blue bar chart representing the CHAIN ASSESSMENT and the green bar chart ROOT ASSESSMENT for partially complaint and so on. I hope you understand me better?

[JeteMc]

This proposal could employ Get & Transform (Power Query) to convert the matrix type data into a records table.
1. Select a cell in the existing data and press the Ctrl + t keys to produce an Excel table (blue/white)
Note that I named the table tbl_Assessment
2. On the Data tab select From Table/Range
3. Paste the following into the Advanced Editor window replacing what was there:

let
    Source = Excel.CurrentWorkbook(){[Name="tbl_Assessment"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"No of control", Int64.Type}, {"Chain Assessment ", type text}, {"Root Assessment", type text}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"No of control"}, "Attribute", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Assessment"}})
in
    #"Renamed Columns"

4. Select Close and Load to
5. Select a location for the new (green/white) table
6. Produce a pivot table from the new table
7. Produce a pivot chart
Let us know if you have any questions.

[QueAd_2023]

Hi All,
I need help to create something similar to this. However, I couldn't find any chart in Excel that matches this:
Attachment 844260
If someone can help, I appreciate.

Thanks!
Adrianne

[AliGW]

Administrative Note:

Welcome to the forum, Adrianne.

We are happy to help, however you are not allowed to piggy-back another member's thread, so please open your own with a suitable title and, if you wish, a link back to this thread.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[QueAd_2023]

Sorry about that. Will do.