Feedback by UserVoice

# 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
Mike commented  ·

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
Mike commented  ·

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)

Mike supported this idea  ·
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

Mike supported this idea  ·
3. ## Known incorrect calculation issue

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

We’ll send you updates on this idea

Mike shared 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
Mike commented  ·

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)

Mike supported this idea  ·
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
Mike commented  ·

This would also alleviate the super silly 5/6th rule!

An error occurred while saving the comment
Mike commented  ·

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.

Mike supported this idea  ·
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

Mike supported this idea  ·
An error occurred while saving the comment
Mike commented  ·

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)

(thinking…)