Feedback by UserVoice

# Mike

## We're glad you're here

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  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Mike supported this idea  ·

1 vote

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Mike shared this idea  ·

## We're glad you're here

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  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Thank you for your suggestion to add a zoom feature to charts! There are currently no plans to devote time to support this in the near future. However, we will continue tracking votes and comments, and will keep this suggestion under consideration for future development.

Thank you again, and please keep sharing your thoughts!
Auston [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  ·

## We're glad you're here

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)