Forum Discussion

clairethnguyen's avatar
clairethnguyen
Frequent Visitor
7 years ago

Help needed with data labeling

Hi,

 

Could you please tell me how I can get the data labels to be shown on the bars, not on top of the chart?

 

T

 

 

Thanks,

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi clairethnguyen,

     

    I believe that you have use a wrong set up for the chart if you want to show each label on the Y axis.

     

    I assume that you are trying to compare different evidence between two years:

     

    Your current set up:

    1. Evidence (Rubic to Others) ---> Legend
    2. Year ---> Axis
    3. Value ---> Values

    Put following field to positions of bar chart:

    1. Evidence (Rubic to Others) ---> Axis
    2. Year ---> Legend
    3. Value ---> Values

     

    Let me know if this help. Thanks.

    • clairethnguyen's avatar
      clairethnguyen
      Frequent Visitor

      Hi,

       

      This is how I set up the data:

      When I tried to change the set up, I couldn't drag more than one values to the "Value" field. Also, this is my raw data if it helps:

      • Anonymous's avatar
        Anonymous
        Not applicable

        Ok, now it is clear that your problem is from your data structure. I suggest to unpivot the data first.

         

        Let say, I have similar data:

         

         

         

         

         

         

         

        By select 2 columns: Year & College collumn -> Transform -> Unpivot Columns -> Unpivot other columns, we have new data:

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Now, when import and create visualization, you can set up bar chart like following:

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Let me know if this work. Thanks

         

         

  • Go to .

     

    Where it says "Position" select "Inside End" or the like and it will move the location of them.