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. Make it easier to find external links

    Not just break them - help us to find where they are. It's time consuming to look in charts, data validation, conditional formatting, data and shapes.

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

    We’ll send you updates on this idea

    33 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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))

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

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

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

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

    16 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 →
  5. Preserve source quoting and separator when saving CSV.

    Currently, Excel alters CSV files to it's internal CSV format whenever the file is saved, even if no changes were made to the file. For example, if I open a CSV file like below (anonymized version of a AWS credentials file):

    User Name,Access Key Id,Secret Access Key
    "somebody",WISKFHEYDSJ2UDFH6XAD,mDHJNSLCF!safsdlds>Flsdfj/Mjufsldkhafdsl

    And then I merely open the file and save it without making any changes, Excel will alter file, removing the quotes:

    User Name,Access Key Id,Secret Access Key
    somebody,WISKFHEYDSJ2UDFH6XAD,mDHJNSLCF!safsdlds>Flsdfj/Mjufsldkhafdsl

    In this particular example, the change is harmless but for more complex CSV files, simply opening them in Excel is sufficient to break other…

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

    We’ll send you updates on this idea

    8 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Great suggestion – CSV hasn’t been an area we’ve been looking into recently, but we’ll reconsider. It looks like this is starting to get some votes fairly quickly. If you like the idea, then please keep the votes coming! That’s the best way to help get this onto our engineering schedule.

    Thanks,
    John [MS XL]

  6. Adding a native interpolation function in Excel

    Interpolation (even a simple linear interpolation) would be a great native function for Excel to have. Something like INTERPOLATE(KnownXRange,KnownYRange, NewX) would be fantastic for anyone who ever has to do this

    The current workaround looks something like this:

    =FORECAST(NewX,OFFSET(KnownY,MATCH(NewX,KnownX,1)-1,0,2), OFFSET(KnownX,MATCH(NewX,KnownX,1)-1,0,2))

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

    We’ll send you updates on this idea

    18 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion, and thanks for showing how you’re using the FORECAST as a workaround. We’ll consider this request along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!

    Best,
    John [MS XL]

  7. Include Median in Pivot Table Value Field Settings

    Current summarization options include count, sum, average, min, max, etc., but median is not available.

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

    We’ll send you updates on this idea

    25 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.

  8. Add a setting/option where all CSV/delimited files are opened as "Text"

    Add a setting called
    "Open text-delimited files (CSV, etc) as text only, with no type inference."

    When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.

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

    We’ll send you updates on this idea

    31 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

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

  10. Allow >31 characters in a sheet name

    31 characters is really quite short. There have been a few times that I've either used abbreviations or left out important identifying words of the sheet entirely.

    Expanding the character limit would complement this suggestion nicely:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10203054-support-multi-row-worksheet-tabs-or-vertical-tabs

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

    We’ll send you updates on this idea

    Accepting Votes  ·  16 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

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

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

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

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

    7 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 →
  14. probability plots

    Implement probability plots similar to those in minitab. In a probability plot, a series of measurements appears as a curve with the quantity being measured on the x axis, and percentiles on the y axis. The curve becomes a straight line if the data is normally distributed. Some probability plots can also be constructed for other distributions.

    7 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 idea. We’ll consider this in a future planning phase. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

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

    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]

  16. Fix broken charts and dependencies when ForceFullCalculation is turned off

    When ForceFullCalculation is set to TRUE and then set back to FALSE, charts will not update until Excel is completely closed and the document re-opened. In addition, you cannot trace formula dependencies either (until restart).

    Whatever is needed (re-build of the dependency tree?) should occur when this is set to FALSE, so that you may continue working on the document.

    19 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 input. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  17. curve fitting

    I would like to have the ability for the user to define the equation for curve fitting. Also would like abilty to define curve equation for 3D curve fits.

    7 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. We’ll consider this in our next planning phase. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  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.

    11 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. Box and whisker charts - log scale on y axis

    I often do stats on highly skewed data sets and use a log scale for the y axis. This does not seem to be an option.

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

    We’ll send you updates on this idea

  20. Trace dependents to graphs and names

    When I clean up others' workbooks, I use Trace Dependents to make sure that I can safely delete a value without messing up any part of the file. However, Trace Dependents does not go to graphs or names, so I have to manually check those.

    I feel that Trace Dependents should trace anything that depends on the cell being traced, not just cells.

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

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

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base