Convert your chart's axis to percentages the quick and easy way

Convert your chart's axis to percentages the quick and easy way || Here's how you can convert your chart's axis to percentages in Excel, without having to convert you data to percentages first.

Like and Subscribe! Thank you!

In this video i show you how you can convert your chart's axis to percentages, without having to convert your data to percentages first. Perhaps you downloaded data from the Internet and created a chart or someone sent you a chart and now you want to convert your vertical axis to depict percentages, without having to convert your data to percentages first.

Select your charts right axis, right click and select Format Axis. From the Number menu select custom. If you simply select percentage, your scale will probably be way off, as Excel wants percentages as a number between 0 and 1 to format them appropriately. Any number over 1 is considered as a number over 100%. For example 1.6 is considered as 160% and it will be formatted accordingly.

Here's how you can format your chart's vertical axis to percentages the quick and easy way, without having to go through any tedious conversions first. Select Custom and in the Format Code text box type:

0\% and click OK.

Now your chart's vertical axis will be formatted as percentages, using the proper scale and representing your data as percentages correctly!

Thanks for watching! Like and Subscribe!

[daiseewalker]

God Bless you. I have been struggling with this for one hour and couldn't figure out a solution. Thank you!!

[melannawray]

Thank you, Thank you, Thank you!! Appreciate your quick and easy help! You make a difference in the lives of others!

[andreasaich]

Your amazing :) I have been trying to figure this out nothing was working. Thank you so much for your help. My hero!!!

[shakirhussainyousfi-shyous]

Thank you very much, finally I found solution 😍

[Jabz-]

Is there a way to hide or remove the percentage symbol at the end but keep the values the same ?

[anita]

Thank you for this solution, however, I want my numbers converted from 100% - example 11 equals 100% and 10 equals 90% etc. How can I show this? My data is only changing to 11% or 10% etc

[umjfyxg]

Please help...I'm using data labels..in label options I'm selecting values from cells..in my data i have zeros and 0.2.. 0.9.. 0.6... 0.3...i want to hide zeros only .. how to do it?

[narendrapunwaney]

Is it possible to have percentage values above 100%. I need to reflect growth of more than 100% and the graph does not allow that

[davidsimwanza]

Its not responding is it format code really 0/%?

[aroundtheworldinxdays]

How do you convert from percentage to normal numbers? Thank you

[yvngslimeto]

Can you tell how to change in from percentages to numbers 5-45 in 5 times

[saallday]

Can you tell me how to change it to 0-100%?

[samkab]

Please help...I'm using data labels..in label options I'm selecting values from cells..in my data i have zeros and 0.2.. 0.9.. 0.6... 0.3...i want to hide zeros only .. how to do it?

[gauravs]

Could you pls tell how to change the bar values to %. Here the scale has been changed to percent but not the bar values.