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. Integrate error handling/value on error for functions such as VLOOKUP

    While functions like IFERROR and ISERROR exist, it complicates things to have to wrap each function in an error checker.

    E.g.
    =IFERROR(VLOOKUP(C2,A1:B6,2,FALSE),"not found")
    could become:
    =VLOOKUP(C2,A1:B6,2,FALSE,"not found")

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Waterfall

    is there a way to add multiple data series along the horizontal axis in a waterfall chart?

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

    We currently don’t support multiple series in a waterfall chart. However, we’ll consider this for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

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

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

  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…

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

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

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

  8. Allow the pivottable to not aggregate data (e.g. show values)

    I need to create a matrix in Excel that doesn't aggregate (e.g. Sum/Count) values. The question of how to do this has been asked dozens of times online over the last couple of years, but still there is no solution. Can Excel therefore produce a plain matrix, or allow pivottables to output plain (unmodified) values from the data field list?

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

    We’ll send you updates on this idea

    33 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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]

  10. 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 →
  11. 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…

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

    We’ll send you updates on this idea

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

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

    Thanks,
    Scott [MSFT]

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

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

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

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

    54 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 →
  17. 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]

  18. Auto Refresh Data for Pivot Tables

    I was there was an option to auto refresh pivot tables when data is changed in the referencing data table. I am trying to move massive tabular spreadsheets which rely on cross linking formulas across several worksheets to data tables which leverage pivot tables to produce the data. The data in the data tables can change very frequently and my team need to see the totals (pivot tables) in real time. The only way to do this right now is with VBA macros which isnt reliable it seems.

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

    We’ll send you updates on this idea

    Accepting Votes  ·  4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  19. Do not chart null values

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

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

    We’ll send you updates on this idea

  20. stacked and clustered columns graph

    Pretty often I need to create sales graph. My data are revenue type, outlet and date. I wish I could have a stacked and clustered columns graph. That way, I could compare per month the revenue per outlet and the split par revenue type

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

    Thanks for the feedback. This is an interesting chart type. We will consider it during our planning for the next round of new chart types. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base