Pivot Charts with Data Labels other than Values

Click on the chart. Then click on the Plus sign that appears outside the upper right corner of the chart. Click on data labels and use the right "arrow" to select that you want the information to appear above the bar. Then right click on the data label and select Format Data Labels, Under label options you have choices like Series name, Category name, etc.

Originally Posted by dflak

Click on the chart. Then click on the Plus sign that appears outside the upper right corner of the chart. Click on data labels and use the right "arrow" to select that you want the information to appear above the bar. Then right click on the data label and select Format Data Labels, Under label options you have choices like Series name, Category name, etc.

I know how to create data labels but these labels are based on the value, in the attached spreadsheet "Sum of Holy"

What should appear above the bars is the field "Hey" and not appear under the horizontal axis.

Is this possible?

Actually I put the field "Hey" back to Legend (Series) and selected 'Series Name" as the label option.

But is there a way to do this with the field "Hey" in the Axis (Categories) ? I don't want to distinguish these values by colour.

One of the options is the read the data values from a set of cells. So perhaps you can set up formulas in these cells to get the desired verbiage.