Feedback by UserVoice

Joseph Byrne

My feedback

  1. 834 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    An error occurred while saving the comment
    Joseph Byrne commented  · 

    I agree w/ @Shirley.

    Joseph Byrne supported this idea  · 
  2. 73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for your suggestion! While there are currently no plans for changing the default behavior, you can modify your settings to not plot null values in your chart. You can do this by navigating to the Chart Design ribbon and opening the Select Data dialogue. From there, select “Hidden and Empty Cells” and then choose to show empty cells as gaps.

    Thank you again,
    Auston [MSFT]

    An error occurred while saving the comment
    Joseph Byrne commented  · 

    I received from MS indicating they're considering implementing "do not chart null" but not NULL() owing to the foreseen practical use of NULL() being to avoid charting nulls. I see this as shortsighted. NULL() can achieve the "do not chart" goal as well as other goals, including some not foreseen. However, "do not chart" achieves only a single goal.

  3. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback. We’ll consider this in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    An error occurred while saving the comment
    Joseph Byrne commented  · 

    @Barber: Yes, that's correct.

    An error occurred while saving the comment
    Joseph Byrne commented  · 

    Thanks for considering this. I'm sure the team has a lot of things to work on. I can't say I'm optimistic about improvement. Having seen Excel make only incremental improvements in charting over the years, I was disappointed to find that the leap forward promised by the addition of new chart types fell short of a feature-rich implementation. Given some improvements, these new charts could have a huge impact on customers and become wildly popular.

    Joseph Byrne shared this idea  · 
  4. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback. We’ll consider this in the next round of planning. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    An error occurred while saving the comment
    Joseph Byrne commented  · 
  5. 73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for the suggestion on conditional format coloring for treemap charts! While we don’t expect to devote time to this in the near future, we will continue tracking votes and comments here. We will keep this suggestion under consideration for future development.

    Thank you again,
    Auston [MSFT]

    An error occurred while saving the comment
    Joseph Byrne commented  · 

    Google Sheets supports this, right?

  6. 17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback. This is an interesting chart type. We will consider it during our planning for the next round of new chart types. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Joseph Byrne supported this idea  · 
  7. 1,142 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    Joseph Byrne supported this idea  · 
  8. 6,776 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for the continued interest in this space. While we don’t have specific plans to announce at this time, we have been researching the topic, conducting customer interviews, and are working with the Python team at Microsoft so we can build a plan that we think can address the scenarios you told us about and ensure it can run wherever Excel runs.

    Keyur [Microsoft Excel]

    An error occurred while saving the comment
    Joseph Byrne commented  · 

Feedback and Knowledge Base