Feedback by UserVoice

Anonymous

My feedback

  1. 129 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 suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.

    Anonymous supported this idea  · 
  2. 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()…

    Anonymous supported this idea  · 
  3. 145 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 taking the time to share your suggestion to support new chart types to be used as pivot charts.

    We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We’ll continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again,
    Auston [MSFT]

    An error occurred while saving the comment
    Anonymous commented  · 

    It would be great to have scatterchart, tree map etc. available as pivotcharts. This post is number 3 in its category. Any chance of a comment please Microsoft?

    Anonymous supported this idea  · 
  4. 5 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

    Anonymous supported this idea  · 
  5. 3 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

    Anonymous supported this idea  · 
  6. 4 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

    Anonymous supported this idea  · 
  7. 13 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

    Anonymous supported this idea  · 
  8. 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

    Anonymous supported this idea  · 
  9. 13 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

    Anonymous supported this idea  · 
  10. 12 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

    Anonymous supported this idea  · 
  11. 9 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

    Anonymous supported this idea  · 
  12. 55 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

    Anonymous supported this idea  · 
  13. 22 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

    Anonymous supported this idea  · 
  14. 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

    Anonymous supported this idea  · 
  15. 18 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

    Anonymous supported this idea  · 
  16. 88 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

    We agree that this feature would be useful for many users. The difficulty is that adding this feature would break compatibility for existing Excel users, Data models with this feature would not run in Excel 2013, 2016, or 2019. At this time, we consider compatibility to be more important than this particular feature. At some point in the future we expect to find a way to deal with this compatibility issue, but we won’t be able to address this anytime soon.

    Anonymous supported this idea  · 
  17. 486 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

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Anonymous supported this idea  · 
  18. 10 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

    Anonymous supported this idea  · 
  19. 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

    An error occurred while saving the comment
    Anonymous commented  · 

    This would be great. I need to create a tool with both a scatterchart and pivot tables, both based on the same table. I need two sets of slicers unless I use code. Of course if scattercharts were available as a pivotchart it would not be a problem!!

    Anonymous supported this idea  · 
  20. 9 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 suggestion. We are looking at ways to do this labeling automatically.

    In the meantime, we did provide a way to do this in Excel 2013 but it requires a few steps.

    1) Turn on “Data Labels” for your scatter chart
    2) Open the “Label Options” in the task pane. This can be done by double clicking on one of the data labels.
    3) Check the box called “Value From Cells”. Then select the range that contains the labels for each data point.
    4) Turn off the other extraneous labels in your data label from the “Label Options” task pane.

    Please give this a try and continue to vote on this feature request (e.g. automatic labeling) which will increase its likelihood of getting into the product.

    Thanks,
    Scott [MSFT]

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

    This is fine unless there are a lot of data points. Could you make it available on hover, not just as a full label?

← Previous 1

Feedback and Knowledge Base