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

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

    We’ll send you updates on this idea

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

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

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

  4. Extend VLOOKUP() and HLOOKUP()

    Extend the lookup functions so they can lookup left/up as well as right/down. That will save us having to build and maintain unintuitive formulae combining INDEX() and MATCH().

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

    We’ll send you updates on this idea

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

    Thanks for taking the time to post a suggestion Malcolm! We’ll be taking a look at lookup functions. There’s a number of votes on the site for them – I’m not going to merge all of them though because different posts are asking for slightly different things. Please keep voting for the ones you want to see most!

    Cheers,
    John [MS XL]

  5. Coloring chart items by referencing to fix RGB-colors

    If you create several charts in a workbook file or creating several charts in different workbooks you have to control, that a special item has the same color in any of these charts.
    In an enterprise environment this is a special need for reporting. You have to do it manually and you have to control any chart after updating because of filtering, resorting or adding new items.

    I imagine, that there could be an option button, that connects a chart to a reference file. This file can be stored locally or in an enterprise environment. The named items of a…

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

    This is an interesting idea. We’ll consider it during our next round of planning for a future release. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  6. Add a zoom feature to charts

    In any line chart sometimes the lines are so close that we can not see the differences. Especially when we add one (or more) trend lines.

    At this point we need to zoom into the chart.

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

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  7. Fix X axis formatting for graphing histograms

    I want to graph data from Histogram function to produce column graphs. Histograms have boundaries for each category. When graphing you can't get the column between the boundary lines on the graph and get the axis labels to line up with the tick marks. If you position axis on tick marks you get the lower boundary label of the category centered on the tick mark which is centered under the column. If you position between tick marks you get the lower boundary label centered under the column and not on the lower boundary. I need to get the column between…

    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. This is an area we are looking into improving. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  8. Apply the right format to chart labels on French Excel with thousand formatter

    On cells with a format such as
    ActiveCell.NumberFormat -> #,##0.00,k

    ActiveCell.NumberFormatLocal -> # ##0,00 k

    ... the corresponding label value in a chart is mis-diplayed on Excel French version.
    It is displayed as "123 456,00 k" instead of "123,46k"

    Same problem with million format (2 commas or 2 spaces in localized version)

    Could this be corrected; it is very frustrating. Thank you

    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  ·  Flag idea as inappropriate…  ·  Admin →
  9. Scatter Charts with Group-By from third data series

    This is a basic charting function that falls in the gap between regular Scatter charts and also Pivot Charts. You should be able to plot Y against X while grouping by a third column of categories. This might be helpful in other chart types too, though is particularly vital for scatter charts.

    The question was asked here on SuperUser:
    http://superuser.com/questions/750353/excel-scatter-plot-with-multiple-series-from-1-table

    I believe it would work better for this functionality to be brought into Pivot Charts in preference to regular charts - regular charts break too easily when data changes, while Pivot charts are quick to set up and have most…

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

    We’ll send you updates on this idea

  10. Easy method for exporting charts to other formats

    Currently it is not possible to easily export excel charts to other formats (e.g. png, eps, pdf, etc.) even in the excel 2016. The ability to do so easily (via the context menu for example) without the need to use any external software would be so handy.

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

    Today, this can be done via a VBA macro. However, we can definitely see the value in doing this through the UI. We’ll consider this in our future planning.

    8/5/16
    We’ll be posting to the Excel UserVoice home page, the features which we’ll be implementing in the near future. To be clear though, we are focusing on features which have the highest customer interest which typically have hundreds of votes.

    Thanks,
    Scott [MSFT]

  11. Confidence Interval for Error bars

    Add Confidence Interval as an option for error bars in charts and pivot charts.
    There is already a confidence interval function. This is a feature of competing software like JMP or Minitab.

    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 in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  12. Include ThinkCell add-on waterfall chart capabilities into Excel charts

    ThinkCell Waterfall add on to Excel https://www.think-cell.com/en/support/manual/waterfall.shtml has more business capabilities comparing to Excel own waterfall chart.

    18 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 →
  13. Give user option to NOT take selected/all Defined Names to new workbook when copying worksheet

    If you copy a worksheet from one workbook to another, Excel currently also automatically copies ALL Defined Names (even if there is no range in the source workbook to which these refer!). It will also copy without warning names with a different scope to an existing name in the target workbook (i.e. If an existing name has Workbook scope, a copied Sheet scoped name will be copied without an warning of the duplication!). This can result in a huge number of redundant or conflicting Names in the target workbook.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. Quick add vertical or horizontal bars with a given value to a chart (aka reference lines)

    Common things that are very hard to do in Excel, should be easy to do and most people implement by drawing with a shape instead of using Peltier's workarounds:


    • Add a vertical/horizontal line at a given value. Could be linked to a range. Could have a legend.

    • Add a vertical/horizontal line at the selected datapoints' value.

    • Add a vertical/horizontal line at the last series' point value.

    25 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 the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  15. Create Vector Sparklines for easy scalability and use in Powerpoint or other programs

    Exporting sparklines from Excel is not very flexible. When copying and pasting sparklines into a PPT placeholder, the placeholder must be exactly the height of what is being pasted or the sparklines appear in the wrong size.

    Scaling the sparklines up results in a highly pixelated image and reduces the usefulness of sparklines across different programs. Creating a way to have vector-based sparklines without a background fill that can scale would be amazing.

    22 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 round of planning for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  16. Data Labels disappearing from charts

    This is a real problem !! When you refresh a picot chart the Data Labels either totally go away or some of them do... It's inconsistent .

    This same problem was inherited by the Web version btw.

    16 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 →
  17. Do not chart null values

    Chart defaults to plotting null or ' values as zero. The default should be to not plot null values

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

    We’ll send you updates on this idea

  18. Enable better control of treemaps

    Done right, Treemaps are a generalization of Marimekko plots. But, we need to be able to control the maps. E.g., control whether a level-one group stretches thinly from the bottom to the top versus being more square and stacked under another level-one group. Also, labeling has to be better--you should at least meet (if you can't exceed) the features in Jon Peltier's add-in.

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

    Thanks,
    Scott [MSFT]

  19. Paste Excel charts into Word as EMF by default (not big blurry PNG!)

    Charts pasted to Word as Enhanced MetaFile look better and are much, much smaller that the PNG files generated by default. This has consequences for PDF exporting. A Word report with more than a couple of charts ends up as a multi-megabyte PDF file, when using EMFs yields files in the low hundreds of kB. Please add an option in either program to use EMF as the default format.

    22 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 feature suggestion. We’ll definitely consider changing this default. Please continue to vote on this feature idea which will increase its chance of getting in the product.

    Thanks,
    Scott [MSFT]

  20. Prominent Manual Calculation Mode warning

    Given the great danger of not realising that calculation mode is set to Manual, it would be very beneficial if a "Manual Calculation Mode" indicator (in bright fire-engine red!) was displayed (and visibility maintained until calc mode is switched back to non-manual) in a prominent location - such as in the Title Bar to the left of the Minimize button.

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

    We’ll send you updates on this idea

    7 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base