Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

X axis in bar chart

Hello everyone,

 

I would like to have the x-axis named according to the data, and not be placed at the top of the chart. For example in the attached picture, the "Banking, Commercial, Education, etc" i want them to be placed in the x-axis under each bar. So how can i do that?

 

Thanks in advance.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Okay.

    So "Banking, Commercial, Education, etc" are separate columns.

    Try the below steps;

    1)Go to Transform Data.

    2)Right click and select the columns which you want in your X axis.

    3)Go to Transform from the upper tab and select 'Unpivot columns'.

    4)You will get a 'Attribute' column.

    5)Go to File ->Close and Apply.

    6)On your report page, pick a visual and drag 'attribute' column on the Axis field and your calculation or measure on the 'Values' field.

     

    If this post helps, then mark it as 'Accept as Solution'.

     

    Regards,

    Sanket Bhagwat.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous .

    Put "Banking, Commercial, Education, etc" in 'Axis' field and not in 'Legend' field.

     

    If this post helps, then mark it as 'Accept as Solution'.

     

    Regards,

    Sanket Bhagwat

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Anonymous,

      Tahnk you for your reply, but when i do that, the bar chart gets empty and all the data are gone.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Put any measure or calculation or any column in the 'Values' field.

         

        Regards,

        Sanket Bhagwat