Can I change data labels on a pivot chart?

[Clair Huntley]

Hi I hope somebody can help me, if its possible, please?

I have a pivot table, and based a pivot chart on it.

But my boss would like the % figure to be at the top of each point, not the actual value, am I able to change that?

I am using Excel 2016 (I was upgraded from 2010 on Tuesday).

Here is a print screen which I hope helps?

Look forward to hearing from you, thank you so much.

Clair

 

[Hui]

Select the chart and then select the Label
Right click on it
Format Label
Select appropriate value

 

[Clair Huntley]

Thank you Hui

I must be doing something wrong as I tried that before I logged on for help.

If I click % column in the label dropbox, I don't get the option to select it as the actual data label.

I only want the % as a label not another column, is that possible? I checked the data source and it does include all the data I am looking for?

Thank you
Clair

 

[Chihiro]

Depending on version of Excel. You can use Label Option to set "Label Contains" to Value From Cells. Set your Pivot Table's % column as data label range.

 

[Clair Huntley]

Thank you so much, that's done exactly what I wanted