Share via

Excel Chart: Multi-level Lables

JP 6 Reputation points
Nov 2, 2021, 9:59 AM

Hello experts!

I have a bar chart that uses a multi-level category, similar to the example below.

To save space in the Y axis labelling area, I'd like to have car manufacturers names on top of each bar while retaining the group names (=country) in the Y axis with a bar for each manufacturer.

Really hope there is a way...

I'm using Office365.

Thanks in advance!
JP

145794-2021-11-02-22-34-31.jpg

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Viki Ji_MSFT 4,466 Reputation points
    Nov 4, 2021, 9:13 AM

    Hi @JP ,
    Thanks for your replay and sharing.

    Per my testing, we may have to manually add it to our data label. The detailed steps are shown in the figure below:

    146523-test.gif

    But because both Country and Manufacturer columns are category columns, we may not be able to keep only the Country column.
    Thanks for your understanding.

    In addition, you can also try to display both in the data bar.
    146389-image.png

    Hope the information is helpful to you.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. henry crist 0 Reputation points
    Jan 10, 2022, 4:10 AM

    Its great. Where do you get this detail? Thanks in advance.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.