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,
Need Help
clairethnguyen's avatar
clairethnguyen
Frequent Visitor
7 years ago

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
7 years ago

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

 

 

  • clairethnguyen's avatar
    clairethnguyen
    Frequent Visitor
    7 years ago

    Hi,

     

    I tried "unpivot columns" but it didn't seem to work, I guess because I have other columns of data (college new name, program name, degree type, etc.) please see below

     This is what I got after unpivot columns and unpivot other columns:

     

    Could you let me know where the problem is? Thanks!