How to Change Decimal Places in Excel Graph (3 Approaches)

While working with Microsoft Excel, we deal with things like money, weight, and length and therefore we employ decimals. While dealing with those we may want the visual representation, thus we use graphs. We utilize decimal places in graphs when we need greater accuracy for partial replacement integers. In this article, we will demonstrate different approaches to change decimal places in Excel graph.

Download Practice Workbook

You can download the workbook and practice with them.

3 Handy Approaches to Change Decimal Places in Excel Graph

The basis for regrouping, multiple-digit multiplication, and other operations in the decimal system is laid by place value. This also serves as a springboard for comprehending other base systems. By highlighting patterns and trends that are hard to spot in the data, Excel graphs aid in understanding the information in a spreadsheet. Let’s follow the methods to change decimal places in Excel graphs.

1. Utilize Data Labels of Excel Graph to Convert Decimal Places

When we change any value on a spreadsheet, the Data Labels update numbers immediately on the spreadsheet which is related to changing data values. Since they provide information on a data series or its single data points, data labels help a graph’s viewers better grasp its contents. We can use this to change decimal places in the graph. Let’s look at the instructions to use this.


  • Firstly, we will insert the graph. For this, select the data.
  • Secondly, go to the Insert tab from the ribbon.
  • Thirdly, click on the Insert Column or Bar Chart drop-down menu under the Charts group.
  • Then, select the Clustered Column under the 2-D Column option.

how to change decimal places in excel graph

  • Thus the graph will display in your sheet.
  • Click on the graph and go to the Chart Elements.
  • Further, go to Data Labels and select More Options.

how to change decimal places in excel graph

  • The Format Data Labels dialog will appear on the right side of your sheet.
  • Furthermore, go to Label Options and click on Number.
  • Subsequently, select Number from the Category menu.
  • Change the Format Code (#,##0).
  • Lastly, click on the Add button.

how to change decimal places in excel graph

  • Now, you can see the decimal places will change in your Excel graph.

Read More: How to Add Decimals in Excel (3 Easy Ways)

2. Use of Format Cells Feature to Change Decimal Places

We use the Excel Format Cells feature to change the appearance of cell numbers in Excel while altering the actual value. Let’s have a look at the steps to change decimal places with format cell features.


  • Likewise the previous method, first, we insert the graph.

  • Then, select the data that have decimal places.
  • Go to the Home tab from the ribbon.
  • Further, to display the Format Cells dialog box, click on the tiny icon under the Number category.
  • Instead of doing this, you can use the keyboard shortcut CTRL+1 to display the Format Cells dialog box.

  • Thus, the Format Cells dialog box will appear.
  • Now, go to the Number menu and select Accounting (as we use Price & Sales).
  • Change the Decimal places, in our case we change 2 decimal places. and click on OK.

  • This will automatically change the decimal places in Excel graphs.

how to change decimal places in excel graph

Read More: How to Reduce Decimal Places in Excel Permanently (5 Ways)

Similar Readings

3. Apply VBA to Commute Decimal Places in Excel Graph

With Excel VBA, users can easily use the code which acts as an Excel menu from the ribbon. To change decimal places with the VBA code, let’s follow the procedure.


  • Correspondingly, Incorporate the graph.
  • Then, go to the Developer tab from the ribbon.
  • Secondly, click on Visual Basic from the Code category to open the Visual Basic Editor. Or press ALT+F11 to open the Visual Basic Editor.

  • Thirdly, click on Module from the Insert drop-down menu bar.

how to change decimal places in excel graph

  • This will create a Module in your workbook.
  • And, copy and paste the VBA code shown below.

VBA Code:

Sub Change_DecimalPlaces()
  Dim objct As Object
For Each objct In ActiveSheet.ChartObjects
   With objct.Chart.Axes(xlValue)
   .TickLabels.NumberFormat = "#,##0"
      End With
   With objct.Chart.Axes(xlCategory)
    .TickLabels.NumberFormat = "#,##0"
   End With
Next objct
End Sub
  • After that, run the code by clicking on the RunSub button or pressing the keyboard shortcut F5.

how to change decimal places in excel graph

  • And, finally, following the steps will change the decimal places in your Excel graph.

Read More: How to Fix Decimal Places in Excel (7 Simple Ways)

How to Configure Excel to Automatically Place Decimal Points

You may modify Excel’s appearance and behavior using the Excel Options dialog box. Editing, copying, pasting, printing, display calculations, formulae, general, and compatible options are among them. Let’s have a glance at the procedures to configure excel to automatically place decimal points.


  • To begin with, go to the File tab.

  • This will take you backstage to the Excel menu.
  • Further, click on Excel Options.

  • Consequently, from the Excel Options, click on Advanced.
  • Scroll down to the Editing options and checkmark the Automatically insert a decimal place.
  • Select your preferable decimal place.
  • Finally, click on OK.
  • Now, whenever you insert any decimal places in your workbook, this will automatically show the place you have changed.

How to Change Axis Scale in Excel Graph

Whenever the chart data are vast numbers that you wish to seem smaller and more legible on the axis, changing the display unit might be helpful. Let’s take a look at the instructions to change the axis scale in the Excel graph.


  • Right-click on any axis of your graph and select Format Axis.

  • This will open the Format Axis window on the right side of your excel sheet.
  • Go to Axis Options and change the Minimum and Maximum values.
  • And, that’s it!

Things to Remember

  • Even after a chart has been generated, Excel makes it simple to change its type. Click within the chart to access the “Chart Design” page, then look for the “Change Chart Type” option and choose the new type of chart you wish to use.
  • When we build a chart in Microsoft Office Excel, the vertical (value) axis, also referred to as the y-axis, has minimum and maximum scale values that are determined. To best suit purposes, we may alter the scale.


The above methods will assist you regarding how to Change Decimal Places in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback. Or you can glance at our other articles in the blog!

Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features