Feedback by UserVoice

Mike

My feedback

  1. 21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike supported this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike shared this idea  · 
  4. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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)

    repost from: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9574854-feature-request-automatic-significant-figures?tracking_code=c1d00dab74a109e7bd8f50131a142f1c

    Mike supported this idea  · 
  5. 70 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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)

    repost from: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9574854-feature-request-automatic-significant-figures?tracking_code=c1d00dab74a109e7bd8f50131a142f1c

  7. 1,181 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

    Mike supported this idea  · 

Feedback and Knowledge Base