Display SharePoint Online Quick Chart Values as Percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-994330%22%20slang%3D%22en-US%22%3EDisplay%20SharePoint%20Online%20Quick%20Chart%20Values%20as%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994330%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20SharePoint%20list%20with%20a%20column%20that%20displays%20numbers%20as%20percentages.%20When%20using%20this%20data%20in%20a%20quick%20chart%20web%20part%20within%20a%20SharePoint%20online%20page%2C%20the%20values%20are%20displayed%20as%20decimals.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20display%20these%20values%20as%20percentages%3F%20I%20cannot%20find%20any%20option%20to%20modify%20the%20value%20format%20within%20the%20quick%20chart%20or%20page%20settings.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-994330%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-994867%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20SharePoint%20Online%20Quick%20Chart%20Values%20as%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994867%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370198%22%20target%3D%22_blank%22%3E%40ccomins%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20isnt%20a%20way%20to%20do%20that%2C%20only%20work%20around%20would%20be%20to%20label%20the%20vertical%20Axis%20as%20a%20Percentage.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Pie%20chart%20which%20you%20have%20probably%20seen%20does%20percentages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995452%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20SharePoint%20Online%20Quick%20Chart%20Values%20as%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20unfortunate%2C%20I%20feel%20even%20the%20most%20basic%20chart%20functionality%20should%20include%20the%20option%20to%20display%20values%20as%20percents%20or%20inherit%20column%20formatting%20from%20the%20SharePoint%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a SharePoint list with a column that displays numbers as percentages. When using this data in a quick chart web part within a SharePoint online page, the values are displayed as decimals. 

 

Is there any way to display these values as percentages? I cannot find any option to modify the value format within the quick chart or page settings. 

 

Thank you

2 Replies

Hi@ccomins ,

 

There isnt a way to do that, only work around would be to label the vertical Axis as a Percentage. 

 

The Pie chart which you have probably seen does percentages.

 

Andy

Hi @Andrew Hodges,

 

That is unfortunate, I feel even the most basic chart functionality should include the option to display values as percents or inherit column formatting from the SharePoint list. 

 

Thank you for your response.