S sachar Member Jul 12, 2015 #1 Dear All, The X Label is in % and I am trying to present with the help of “Format Axis=>number=>Custom” which is wrong (Sample File Attached). Please help me to correct this? Attachments SIX SENSES_INTERACTIVE CHART.xlsx SIX SENSES_INTERACTIVE CHART.xlsx 13.9 KB · Views: 0
Dear All, The X Label is in % and I am trying to present with the help of “Format Axis=>number=>Custom” which is wrong (Sample File Attached). Please help me to correct this?
N NARAYANK991 Excel Ninja Jul 12, 2015 #2 Hi , A percentage value is a value between 0 and 1 ; thus a value of 0.37 , if formatted as Percentage will be displayed as 37%. If a value of 37 is formatted as Percentage , it will be displayed as 3700%. If you want a value of 37 to be displayed as 37 % , you need to use a format such as : # "%" or # \% See the attached file. Narayan Attachments Copy of SIX SENSES_INTERACTIVE CHART.xlsx Copy of SIX SENSES_INTERACTIVE CHART.xlsx 15 KB · Views: 1
Hi , A percentage value is a value between 0 and 1 ; thus a value of 0.37 , if formatted as Percentage will be displayed as 37%. If a value of 37 is formatted as Percentage , it will be displayed as 3700%. If you want a value of 37 to be displayed as 37 % , you need to use a format such as : # "%" or # \% See the attached file. Narayan
