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.
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.
If you want to add these decimal points to this data, just proceed with the following 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.
- As a result, you will get the decimal points of your data increased.
- Hence, you will also see the axis label changed. That means the vertical axis has been changed to decimal points.
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.
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.
- 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.
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.
- 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.
C13= Original Wholesale Price
- 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.
- 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.
So, these are the ways you can follow to change significant figures in a graph in Excel.
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!