Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Link the min and max values of a chart axis to cell value

    It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.

    950 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    96 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  2. Adding comment (tool tip) in chart (to various elements of the chart, data points, etc.)

    To be able to add comments to a specific data labels in a chart (can be bar chart, line chart)

    36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  3. Allow users to control the order of items in the sunburst chart.

    I'm using a sunburst chart to convey status, and visually it would be nice to have the chart in the same order as the items I want to talk about them, so the discussion flows clockwise around the wheel. Having an option for the layout to follow the order in the excel list would be wonderful

    125 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    24 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

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

    Thanks,
    Scott [MSFT]

  4. Embed 3D maps in worksheets

    Add the ability to embed 3D maps within an excel sheet. If you are making an excel-based dashboard, it would be great to have the capability to showcase the map right within the sheet instead of as a pop-out visual.

    50 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the input. We’ll consider this in our future planning efforts. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  5. Conditional formatting in charts

    Add Conditional formatting in charts to control the colour of e.g. a bar or line, depending on the value or content of the data labels. Green if appels, Yellow if bananas and so on.

    128 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  6. Excel 2016 Waterfall Chart ...Enable Save as Template setting

    Enable the Save chart changes (e.g. Colurs on Waterfall) as Template for Waterfall. This is enabled for other Chart Types but not for Waterfall.

    37 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for your input. This limitation is true for all of the new chart types released in Office 2016; e.g. waterfall, histogram, treemap, etc. This is functionality we are assessing to enable for the new chart types. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  7. Rotate sunburst chart (& other controls)

    LOVE THE NEW SUNBURST. Great work, guys - please keep it up. Would like ability to rotate the sunburst chart (just like we can with the regular pie chart) and have much more control over the final product, such as: ability to turn visibility on or off for any segment (sometimes really important segments are not labelled because they are relatively small - please give us control), more control over colors of segments and sub-segments, better font size & text rotation of labels, more data label options such as pop-out / data callout and other options found on pie chart.

    57 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

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

    Thanks,
    Scott [MSFT]

  8. Tighter integration with MS Access

    Tighter integration with MS Access - improve (expand) object model to provide more powerful and transparent integration between Access, Excel and Word. Make it easier to create visual models using flexibility of Excel column / Row structure using MS Access datasets and VBA code.

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  9. Remember the chart type, chart formatting (and template) on Pivot Charts

    When you're charting a pivot table and have a combo chart - say stacked bar chart with a line chart - and you filter your pivot table so that one of the stacked bar elements disappears, the chart replaces the missing element from the line chart. Remove the filter and your line chart is still part of the stacked bar chart.

    I'd like the pivot chart elements to remain in their place even when there's nothing to show because of the filter.

    Additionally, any formatting applied via Chart Templates to Pivot Charts is lost on Pivoting, etc. - this formatting…

    102 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is a known issue which we have concrete plans to fix. However, please continue to vote on this issue.

    Thanks,
    Scott [MSFT]

  10. Creation of PPT slides directly from excel Sheet

    Hi All,

    I would like to see a new feature in excel, where from just one click we can export the excel sheet , charts ,objects in powerpoint slides.

    Regards,
    Rajender

    89 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  11. save chart as image

    It would be nice to be able to right-click on a chart and have an option to save it as an image (jpg, png, ...) to the hard drive instead of copy pasting to another application or using screen capture software.

    25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

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

    Thanks,
    Scott [MSFT]

  12. Conditional format coloring for Treemap chart

    I noticed that the new charts for 2016 have a treemap chart that looks great but is missing other options to have changes in color as oppose to one solid color for different category. Looking to have something that would change color due to changes in value (ie. from negative (red) to positive (green) with an optional midpoint color (black))

    52 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is something we are considering for a future release. However, please keep voting on this feature idea.

    Thanks,
    Scott [MSFT]

  13. Support for Rose charts

    Please could we have support for Rose charts. These are a form of Pie chart where the radius of the segment is used to represent an extra value. These are particular common in metrological, demographic, political and healthcare reporting.

    For example a hospital may want to report on the number of admissions due to alcohol related violence by day of week. In a standard pie chart each wedge could be a day of the week and the angle of the wedge represents the number for that day of the week as a proportion of the total weekly admissions due to…

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  14. Sensible date formatting on X-axis of XY-scatter charts

    If the X-axis of an XY-scatter chart is DATES, then it would be great to have the option to select the x-axis category labels to be spaced by (eg) months, years, etc like you can do for a line-chart. The advantage of being able to use an XY-scatter chart with this proposed functionality is that not all plotted series have to share the same x-series. Thank you!

    75 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is a great suggestion. We’ll definitely consider it as we plan the next round of features. Please continue voting on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  15. Excel 2016 New Chart Types - Experiencing Major Problems

    New Excel 2016 chart types Problems Experienced:
    Can't drag Title
    Can't drag Data Labels
    Can't drag Legend
    Inserted Shapes/Text Boxes are not embedded within chart
    This is a problem.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    There are some limitations with the new chart types introduced in Excel 2016. We are working on addressing the items that you have called out.

    Thanks,
    Scott [MSFT]

  16. Chart series formatting - UI overhaul

    Formatting chart series is currently very cumbersome, particularly on a chart with many series.

    SUGGESTION: make a *series formatting window* open up for a given chart.
    -The window displays all series simultaneously (each series is one row). Each column is an attribute (e.g. line type, line width, marker type, marker line color, etc. etc.). All attributes are also shown simultaneously.
    -It should be possible to easily copy attributes (only some, or all) from one series to another, or to multiple others simultaneously.
    -It should be possible to define and save attribute sets for a series that can then be selected…

    64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    We are looking at several ways to make formatting easier. This is an interesting approach that we will consider.

    Thanks,
    Scott [MSFT]

  17. Intelligent number formatting in chart axes

    Add functionality to automatically adjust x and y axis number formatting to be appropriate to the min and max scaling. This would be particularly useful when the same chart template for dynamic charting and/or running scenarios.

    For example in the following min/max ranges Excel could apply the following number formats:

    0 to 10's - 0.0 (e.g. 5.0)
    0 to 000's - #,##0 (e.g. 5,000)
    0 to 000'000's - display units millions (e.g. 5.0 and add million label next to chart)

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  18. Float/Hover Charts that are Objects on a Sheet so they stay in vew as you scroll

    Introduce a setting that lets you float/hover a chart that's an object in a sheet so that when you scroll the sheet, the chart stays in that place and viewable on the screen as you scroll.

    Think of 'position: fixed' in CSS:

    #Chart {
    position: fixed;
    right: 10;
    top: 10;

    You could also step it up a notch and have the button appear on mouse hover somewhere on the chart that has the option to float: on/off.

    Yes I know you can split or freeze the screen but it wastes a lot of screen real estate.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    That’s an interesting idea. We’ll definitely consider this in our planning for the next release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  19. Add vertical waterfall chart in Excel 2016

    Add vertical waterfall chart in Excel 2016 (labels in Y axis) in addition to the existing horizontal type (labels in X axis)

    Add optional lines between bar gap

    53 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    This is an interesting idea. Could you provide an example of the layout that is of interest? Is it simply a 90 deg. rotation of what we have in XL 2016?

    7/26/16
    Thank you for the further details in your comments. We are using this forum to gauge the relative importance of feature requests. The number of potential feature improvements is very broad so we need to focus our resources on the most important ones.

    Please continue to vote on this feature idea which will increase its likelihood of getting implemented.

    Thanks,
    Scott [MSFT]

  20. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is an area we are actively looking at for our future planning. Pease continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base