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. 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.

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

    We’ll send you updates on this idea

  2. allow 3d maps to use maps other than bling

    Bling maps falls very short of needs when dealing with remote areas of the world such as Tanzania. The 3D mapping tool would be fantastic if I could use it with a map that is useful for my area.

    6 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 →

    Thanks for the feedback. By “Bling” I assume you mean “Bing”. Could you comment on the regions that don’t have good coverage and what is missing?

    Thanks,
    Scott [MSFT]

  3. 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.

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

    We’ll send you updates on this idea

    6 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]

  4. Checkbox to make positive and negative custom error bars the same

    Please add a checkbox to the window for entering cell ranges with custom error bar values to set positive and negative error bars to be the same, so that you don't have to select the same cell range twice.

    3 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 →
  5. 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.

    20 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]

  6. Waterfall Chart improvement - Incorrect display when cumulative values are negative

    Incorrect display of values when cumulative values are negative - i.e. below horizontal axis. It looks like the values are still above the axis, as the x axis does not cross the y at 0.

    P.S This is based on original thread "Waterfall Chart Improvement Suggestions". As requested by Admin, I am splitting each topic into separate ones.

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  7. Verbatim analysis (word clouds, etc.)

    Often, I find myself needing to read through a list of open-ends or other verbatim that is captured in an Excel file. It would be great to have some way to do a quick open-end/verbatim analysis and generate a word cloud or even just a list of the top themes by frequency of mentions.

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

    We’ll send you updates on this idea

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

    Thanks for the feedback. We’ll consider this for a future release.

    Thanks,
    Scott [MSFT]

  8. Enhance Map charts so more geographic details such as cities, latitude and longitudes, and street address data can be mapped

    Enhance Map charts so more geographic details such as cities, latitude and longitudes, and street address data can be mapped

    3 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 →
  9. 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))

    65 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 feedback. This is something we are considering for a future release. However, please keep voting on this feature idea.

    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

    96 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.

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

    We’ll send you updates on this idea

    13 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. Waterfall Chart improvement - Plot area can't be adjusted.

    Plot area can't be adjusted. It's not possible to change this - only chart area can be changed. This is applicable to the other newly introduced charts as well.

    P.S. This is based on original thread "Waterfall Chart Improvement Suggestions". As requested by Admin, I am splitting each topic into separate ones.

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  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…

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  15. excel 2016 default chart not working on personal templates

    you cant set your own chart template as a default chart in excel 2016 - this is something you can do in all previous versions. Please fix it!!

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

    We’ll send you updates on this idea

    9 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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!

    81 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]

  17. Waterfall Chart improvement - Connector Color and shape outline to be selectable

    Connector color and shape outline cannot be adjusted. Allowing the users to select color and outline would be great.

    P.S This is based on original thread "Waterfall Chart Improvement Suggestions". As requested by Admin, I am splitting each topic into separate ones.

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  18. 3D Scatter Chart

    I currently create 3D scatter charts by taking 3D location data, transforming,projecting to 2D data, and using 2D scatter chart to output the results.

    I would like Excel to have 3D scatter Chart where user selects x, y, and z axis, and in the chart properties adjusts rotation, viewpoint (or isometric) for perspective, and zoom level.

    The chart properties should be able to reference cells, such that automation would be available (ie, cell A1=rotation angle).

    Also essential to this would be a formula which can return a blank to be read by chart, so that gaps can be plotted. There…

    8 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 →

    We’ll definitely consider this chart type for a future release. Thanks for the feedback.

    -Scott [MSFT]

  19. Add non parametric regression trend line options.

    Locally weighted scatterplot smoothing can be useful for fitting a curve to data that is highly variable or non periodic - and in which linear, exponential or polynomial type trend lines are not appropriate.

    One of the two related methods termed "Loess" and "Lowess" would be very useful to have.

    2 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 →
  20. Ability to select data on 3D Map by dragging over an area

    Once data is charted on map drag the mouse over an area to select just the results in that area. Would be useful for CRM marketing campaigns etc.

    6 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 →

    Great feedback. Selection is an area we plan to improve with 3D charts. Please continue voting on this feature idea.

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base