Thread: Need to show percentage value in pivot chart instead of decimal value
View Single Post
 
Old 03-23-2020, 07:22 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Right-click below x-axis (on part with axis labels) and select Format Axis;
In Format Axis popup window (probably at right of screen), expand NUMBER;
In Category selection select Percentage. Set decimal places to 0.
Done!
Reply With Quote