How to Create Multi-Category Chart in Excel
HTML-код
- Опубликовано: 11 сен 2024
- Multi-category chart or multi-level category chart is a chart type that has both main category and subcategory labels. This type of chart is useful when you have figures for items that belong to different categories.
In this tutorial, you'll see how to create a multi-category chart in Excel.
Note: This tutorial uses Excel 2013. In other Excel versions, there may be some slight differences in the described steps.
To see the written instructions, go to: www.excel-board...
Straight to the point, Calm voice and clear presentation.
Thank you Parvana. 🌷
I needed to accomplish this for a pivot chart in a way that no manual formatting was required at any point (start, data/categories changes, refreshes, pivoting the chart, etc.). What I did was that in the data source of the pivot chart I duplicated the category column, then in the "Legend (Series)" section, which are the columns of a pivot table, I put the duplicated field while keeping the original one in the "Axis (Categories)" section, which is the rows of a pivot table, some error labels may appear if you are using calculated fields in your pivot table, if that is the case (which was mine), you can get rid of those in the pivot table options by defining the setting of how to show errors as nothing, that made the trick while keeping the pivot chart structure like the one shown in this video, which is very good for easy reading, I hope this helps someone looking for how to do this with a pivot chart without having to manually format anything because I searched for several hours and didn't find how to do it the way I needed, but this video was shown in the results of my searches, so I'll leave the information here.
jesus christ i was struggling because i couldn't find a tutorial like this one THANK YOU SO MUCH OH MY GOD
Thanks for commenting. Glad you found it useful.
Thank you very much!!! To be honest, I was exactly looking for this. It was really useful and covered in a very good way.
simple and useful. I was looking exactly for this
Best video for this! Straightforward and fast. Good job!
Thanks for commenting. Glad you found it helpful.
Clear, concise and to the point. Good video.
Simply amazing... Right arrow then F4 key shortcut was really awesome and would be helpful in future... Thanks allot!
Thank u for sharing this amazing video. I wanted it for my thesis and was just unable to get the right video. Thanks for saving my day. God bless you
Thanks for commenting. Glad you found it helpful.
This is really awesome.. Thanks for all the Tips. Very interactive and clean.
Thank you so much !! i was looking for exactly this. This is very helpful! and it was very understandable and clear at the same not
not confusing at all
i loved it
thank you so much !!😍😍😍
Your way of teaching is very good
Thanks for commenting. Glad you liked it.
damm, this tells more story when you have more categories. This is what I need, thanks a lot
This was so helpful, exactly what I needed, thank you!
Thanks for the tutorial, very useful
Omg... Thank you so much for this!
Thanks for sharing, it's very helpful.
Thanks for commenting. Glad you found it helpful.
Thank you so much! It was very helpful!
Simple and so useful for without computer background person thank you mam 😃
Hey thank you for making my work Easy
Thanks so much!! :-) was really helpful!!
Thank you so much 💖
Very helpful. Thank you for posting it.
Thank you!
Hi thanks, how to retain this formating & color. When i refresh the data..its going back to default color
How to turn vertical alignment of first category in horizontal one?
Awesome!
saviour!!
@ Excel Board. Thank you for the very informative video, I was really looking for this. However, please how do you include a figure legend to describe only the three categories?
How did you place category names right in the middle of the graph?
Hello mam... I need Ur help plz ...I need to add years ..I added but that doesn't appear on chart ..can u help me out plz
I'm waiting ur reply!!!!!
Where u have added shoes, bags etc... There I had to add years .. I did so, but that very column doesn't appear on graph, rest appears
How to make the text in the subcategory horizontal?
Very good
Nice one., is there download link
How do you sort the categories in alphabetical order (accessoires, clothing, shoes)?
You may be able to do that under the chart formatting menu for the data series, but not sure. Otherwise, sort your source data and the chart will follow.
The Subcategories do not populate when I select a 2D Bar chart. Could you please advise?
yeah, choose horizontal column chart
Target vs actual please
Is this possible on a waterfall chart?
Excel seems to suck until you learn how to use it.