How to format chart axis to percentage in Excel?
Normally the number labels in chart axis are in general format in Excel. Sometimes, you may want to format the number labels and show them as percentages. Now I will show you the detailed method to format chart axis to percentage in Excel easily.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
For example you have a data range as below screenshot shown, and after adding a chart in Excel, you can format a certain axis and change all axis labels to percentage easily as below:
1. Select the source data, and then create a chart with clicking the Insert Scatter (X, Y) and Bubble Chart (or Scatter) > Scatter with Smooth lines on the Insert tab.
2. In the new chart, right click the axis where you want to show labels as percentages, and select Format Axis from the right-clicking menu.
3. Do one of below processes based on your Microsoft Excel version:
(1) In Excel 2013's Format Axis pane, expand the Number group on the Axis Options tab, click the Category box and select Percentage from the drop down list, and then in the Decimal Places box type 0.
(2) In Excel 2007 and 2010's Format Axis dialog box, click Number in left bar, click to highlight the Percentage in the Category box, and then type 0 into the Decimal places box.
Excel 2013 and higher versions:
Excel 2007 and 2010:
4. Close the Format Axis pane or Format Axis dialog box. Then you will see all labels in selected axis are changed to percentages in the chart as below screen shot shown: