Help needed with data labeling

[clairethnguyen]

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,

[Anonymous]

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]

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]

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]

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!

[JoyCornerstone]

Go to .

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