View Single Post
 
Old 05-26-2017, 02:49 PM
coma08 coma08 is offline Windows 10 Office 2016
Novice
 
Join Date: May 2017
Posts: 2
coma08 is on a distinguished road
Default Format Legend to Percentage

I am trying to change the Legend in my stacked chart to show %s, i.e. from .50 to 50%. I tried Format Legend, but I do not get the option to format Number.

The chart is linked to a pivot table. Is that my problem? I formatted the pivot table to %s, but it's not transferring over.

Thanks, any help is much appreciated.
Attached Images
File Type: jpg Untitled.jpg (29.1 KB, 14 views)
File Type: jpg Untitled2.jpg (37.2 KB, 14 views)
Reply With Quote