Excel 2013 PowerPivot Charts : Format Data Labels as Percentage

You want to add Data Labels to your Excel 2013 PowerPivot chart and format as a Percentage.

First right click on your chart bar or line, select “Add Data Labels”, then “Add Data Labels” again.

AddToDataLabels

 

This will add a data label, but you now need to format it.  Right click the actual data label that was just created, and select “Format Data Labels”.

AddToDataLabels_FormatDataLabel

 

Now under Format Data Labels, scroll down to Number, expand this, set the Category to Percentage and set the number of decimal places.

AddToDataLabels_FormatDataLabelPercentage

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s