Create a Multi-Category Chart in Excel | Multi-Level Category Labels in Excel Chart

[@IvanCortinas_ES]

Thanks Chester. The bar chart already looks pretty good. Great video.

[@JP-ut2iw]

Always explains simple yet clear! Thanks Chester! Is there a way only to show branch names and hide the other two sub categories, while the bars still showing all individual customer types? To save space on the left hand side, I would like to have the labels for the customer types on top of each bar BUT keep them grouped by branch and show branch names only on the left. Thank you!

[@leonardostreit3527]

Great explanation help me a lot! Do you if there is a way to adjust the text because my two first series categorys has bigger names

[@BicycleFunk]

Hmm, when I do this I get repeats of the main category - this is with multi-level categorization. Will try again tomorrow!

[@Vutsman1]

How do you add grid lines that extend the category markers into the chart area?

[@sumeeet6155]

but can you make a stacked bar chart here and show the total on the top? with Multi-Level categories.

[@akanshatiwari2398]

How to sort the data withing the subcategories.??

[@samkab677]

Can slicers be added?

[@axion8788]

Useful, as usual but Excel should make this easy to do without the clever workarounds you demonstrated.