# Mike

1. ## Feature Request: Automatic Significant figures.

(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment

I've not seen anything in over two years, despite multiple threads and a comprehensive solution framework (see below).

I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.

Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)

An error occurred while saving the comment

There are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.

The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20

The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.

The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0

The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.

I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.

Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)

2. ## Add more options for custom number formatting for chart axis or allow for conditional formatting there

(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

3. ## Known incorrect calculation issue

1 vote
(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

4. ## Support formatting or rounding to user-specified number of significant figures

(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment

There are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.

The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20

The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.

The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0

The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.

I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.

Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)

5. ## Add a zoom feature to charts

(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

Thanks,
Scott [MSFT]

An error occurred while saving the comment An error occurred while saving the comment

Excel charts definitely needs to have a native scroll, scale and zoom feature. Every chart should be able to scale down from all points to x number of points, zoom in and out (which is slightly different than scaling), and scroll along both the x and y axis.

This would make the entire chart experience so much better!

Currently I have to build super complex and memory intensive double dynamic index formulas to pull this off, which only serves to stall out excel for up to a few minutes. if such features were native, my charts would be much more user friendly.

6. ## have a setting for number of significant figures rather than just for number of numbers to the right of the decimal

(thinking…) Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment

There are three ways to handle this, as a formula, as a number format category and as a custom number format. I think that all three are necessary and easy.

The formula would work just like ROUND but truncate to number of significant digits rather than just number of digits. Notice the trailing zeros, they are important.
SIGFIG(2017, 2) = 2000
SIGFIG(2.017, 2) = 2.0
SIGFIG(0.2017, 2) = 0.20

The number format would operate like the Number, Currency, Accounting, and Percentage categories, with a simple selector to determine the number of digits.

The custom number format should look something like: “ !! “ to round to 2 significant figures and “ !!!!! “ to round to 5 significant figures. It would not matter if the number was an integer or a decimal.
2017 with “ !! “ = 2000
2017 with “ !!!!! “ = 2017.0
2.017 with “ !! “ = 2.0

The formula should absolutely truncate the resulting number such that future calculations only use the digits displayed. Whether the number formats truly truncate or just alter what is displayed (while leaving the original value alone) I will leave to brighter minds.

I would also like to see the outlined options dynamically enabled. By this I mean:
round A1 to match the significant digits of cell A2, preferably without having to resort to some LEN formula.

Something like SIGFIG(A1, A2) or SIGFIG(2017, A2)

7. ## Link the min and max values of a chart axis to cell value 