How to Change Significant Figures in a Graph in Excel (3 Ways)

Generally a graph in Excel is used to create a trend and make the data more understandable to the readers. You may have added axis titles in a graph and edited the legends of it. But, sometimes you may need to change significant figures in a graph in Excel. In this article, I will show you how to change significant figures in a graph in Excel.


Download Practice Workbook

You can download the practice book from the link below.


3 Simple Ways to Change Significant Figures in a Graph in Excel

Let’s say, we have got a dataset of different products and their corresponding wholesale price per kg for a fruit selling shop.

Change Significant Figures in a Graph in Excel

We have created a column chart based on the dataset. You may proceed with your created graph/chart (i.e. Stacked Bar Chart/ Pie Chart etc.)

Change Significant Figures in a Graph in Excel

Now, Our aim is to change significant figures in this graph.

In this section, I will show you 3 simple and effective ways to change significant figures in a graph in Excel. Let’s check them now!


1. Adding Decimal Points to Graph Data

Let’s say, in our dataset, the wholesale price of the products has decimal points, but we have not shown that in a data table.

Change Significant Figures in a Graph in Excel

If you want to add these decimal points to this data, just proceed with the following steps.

Steps:

  • Here, all you have to do is to select the data range> go to the Home tab> click the icon describing the Increase Decimal point.

Change Significant Figures in a Graph in Excel

  • As a result, you will get the decimal points of your data increased.

Change Significant Figures in a Graph in Excel

  • Hence, you will also see the axis label changed. That means the vertical axis has been changed to decimal points.

Change Significant Figures in a Graph in Excel

Note: As the change is so small, it may not be significantly noticeable.


2. Changing Data in Excel Graph

Let’s say, in the previous case, the owner of the shop decided to purchase Guava instead of Watermelon. So, the significant column in the graph for Watermelon will be changed.

Change Significant Figures in a Graph in Excel

So, we have to replace the product and the corresponding price of Guava in the place of Watermelon. In order to change this data, follow the steps below.

Steps:

  • You have just one task to do here. Input the product name (i.e. Guava) and the price ($28) in the relevant cells of the previous value (i.e. Watermelon)

  • Hence, you will find that the corresponding figure of the column and its shape has been changed due to the replacement of the previous value.

Change Significant Figures in a Graph in Excel


3. Rounding Significant Figures

For our previous set of data, we have shown the wholesale price per kg of the individual products. Now, let’s say, the owner of the shop has bought 1000kg of each of the products. Here, I have shown the total price for each of the products.

And the corresponding graph has been shown below. You will notice that each column shows the products’ corresponding value.

Now, let’s say, the wholesale seller has given consent to keep the round figure price for the first three products (i.e. Apple, Avocado, Orange ). So, we have to round these significant figures of the prices of these 3 products to change the corresponding figures in the graph.

In order to do so, just proceed with the steps below.

Steps:

  • First, create a separate table with headings (i.e. Wholesale price and Rounded price). Copy the three data that you want to make round figures in that table.

  • Here, we will use the ABS, LOG10, INT, and ROUND functions. Enter the following formula to the cell where you want the round price.
=ROUND(C13,3-(1+INT(LOG10(ABS(C13)))))

Here,

C13= Original Wholesale Price

Formula Breakdown

  • ABS(C13)= The ABSOLUTE function returns positive value. So it returns 46426.
  • LOG10(ABS(C13))= LOG10(46426)= 4.6667
  • INT(LOG10(ABS(C13)))= INT function returns nearest lower integer of 4.6667= 4
  • 3-(1+INT(LOG10(ABS(C13))) = 3-(1+4) = -2: It gives the remaining digits of the number excluding the first 3 digits.
  • ROUND(C13,3-(1+INT(LOG10(ABS(C13)))))=ROUND(46426,-2)=46400

  • Now, drag the Fill Handle tool down to Autofill the formula.

  • Now, copy only the cell values of the rounded price and paste them to the previously made whole price column from which the graph was created.

  • As a result, you will see that the graph has changed the corresponding columns by changing the data into the round figure.

Change Significant Figures in a Graph in Excel

So, these are the ways you can follow to change significant figures in a graph in Excel.


Conclusion

In this article, I have tried to show you some methods of changing significant figures in a graph in Excel. I hope this article has shed some light on your way of altering significant figures in an Excel graph. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy. Have a great day!

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo