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

    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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Waterfall

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

    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 →

    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. easy way to plot a maximum curve for multiple curves at once. upper envelope curve

    Right now there isnt a way to plot an envelope curve easily in excel without first finding arguments to find the data that you are looking for. With some data sets this can be really difficult and it would be nice to find the max and minimum y for any given x.

    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 →
  4. Chart gridlines on top of series as option

    Allow users to optionally select which 'layer' of a chart the gridlines sit. eg, I have an area chart to show a target, with a line of actual performance over it. I would like the gridlines to show over the area layer of the chart, but sit behind the lines.

    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 →

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

    Thanks,
    Scott [MSFT]

  5. Hiding a PivotField deletes right PivotChart Axis

    Have a PivotChart with 2 series bound to the left AxisGroup and 2 series bound to the right AxisGroup.
    Now hide the PivotField corresponding to one of the series bound to the left AxisGroup.
    ==> Excel deletes the right Axis and binds all series to the left AxisGroup; see Demo macro.
    That is not desired.

    Sub Demo()
    Dim lcCO As Excel.ChartObject
    Dim lcLO As Excel.ListObject
    Dim lcPT As Excel.PivotTable
    Dim lcWS As Excel.Worksheet

    Workbooks.Add
    Set lcWS = ActiveSheet
    With lcWS
    .[a1] = "Time": .[b1] = "Left1": .[c1] = "Left2": .[d1] = "Right1": .[e1] = "Right2"
    .[a2] = "0:00:01": .[b2] =…

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

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

  7. For technical users of Excel, we absolutely need more symbols in the charts. Double new symbols: simply flag all existing symbols.

    Simply adding "flags" to all existing symbols, with optional color and fill options (for the symbol), can create double the number of symbols currently available. This is needed for highly technical charts. Also, if the symbol choices were made at the time the data were selected, much time could be saved from adjusting the chart later. "Flags" are simply a 45-degree-line tick mark on the upper right side of the symbol.

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

    Thanks,
    Scott [MSFT]

  8. There is a bug where charts sometimes do not update

    This happens only rarely, I have noticed it a couple of times in larger spreadsheets. Something in the spreadsheet gets changed, formulae recalculate and the values in the chart range change accordingly, but the chart itself does not change.

    The only thing I have found that can trigger an update consistently is this code:

    Set sht = ActiveSheet
    For Each co In sht.ChartObjects
    co.Activate
    For Each sc In ActiveChart.SeriesCollection
    sc.Select
    temp = sc.Formula
    sc.Formula = "=SERIES(,,1,1)"
    sc.Formula = temp
    Next sc
    Next co

    Issue is discussed here: http://stackoverflow.com/questions/4902703/excel-chart-wont-update

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  9. allow to make the background of a sheet transparent (except the tab)

    this would be a simple way to create multilayer drawings with shapes
    reasons for this idea:
    -an employee or executive has usually no time to learn Illustrator.
    - in the beginning, spreadsheet programs were a kind of Lego allowing a user to build a simple or very complex model easily.

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

    We’ll send you updates on this idea

    1 comment  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

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

    Thanks,
    Scott [MSFT]

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

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

    Thanks,
    Scott [MSFT]

  11. Make points into objects

    Make scatterplot data plot points into objects that can be selected with the mouse in order to remove them from a regression or move them to another series.

    2 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 and further details. We’ll consider this in our next planning round for a future release. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  12. Separate Update chart button, hotkey

    Need separate option for run graphic update automatically and separate button for run chart calc. This seems to be very processor intensive and slows down large table updates that happen before chart updates.

    1 vote
    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. 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]

  13. Allow option to change gridline spacing for charts

    Allow an option called "spacing" in "Major Gridline Options" in charts.

    1 vote
    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 for a future release. In the mean time, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  14. Total least square fitting on graphs & Deming regression in line-of-best-fit functions

    Least squares fitting only minimizes the error in dependent variables. The error in the independent variables is ignored.

    For the graphing of any data obtained by measurement, such as in science, we should consider the error in all variables, and so we should have an option to plot curves of best fit based on total least squares fitting.

    It would also be nice to have an option to specify Deming regression in some of the line-of-best-fit-related functions such as SLOPE, INTERCEPT, FORECAST, LINEST, TREND, PEARSON, and RSQ.

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

    Thanks,
    Scott [MSFT]

  15. Network functions, like ping() or nslookup()

    Handy if you have a column of hostnames or IP addresses.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Interesting idea, thanks for the suggestion. I’d be interested to know if there are other functions in this area that people also want to see. I’ll check back soon to see how many votes this is getting, so if you like the idea be sure to vote for it.

    Cheers,
    John [MX XL]

  16. Cortana should learn excel syntax so that I don't have to

    Cortana should learn excel syntax so that I don't have to. Pretty simple, for users that don't want to learn functions such as left/right, they should simply be able to say "Cortana, take the last 3digits off that column and put them in the next column" "Make me a pie chart with the colors red white and blue"

    (2015-11-05 Dan [MS] - added to Formulas and Functions category)

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

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Expose more related charting objects in VBA (a points' values, range, series, etc)

    It is not possible to access a point's values or range from VBA. We have to parse the point's name (S3P14), the go to the third series' 14th cell in the x values range to access the points' value or range.

    It is also not possible to access a series' legend entry as a property from VBA.

    There are many examples of this kind of "incompleteness" of the VBA charting object model. It would be great if these related objects could be exposed, to simplify code.

    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 →

    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.

    Could you further comment on the other areas which you feel are incomplete?

    Thanks,
    Scott [MSFT]

  18. Improve graph creation and customization

    When graphing it's a nightmare to make something with error bars or to create a good legend ... etc. Please make it possible to insert a group as a single value for a bar chart. Select the group, ask the chart to display the mean (or median or whatever statistic), and from there ask it to display error bars and so on.

    Speaking of error bars, I think it's necessary to add the option of changing the width of the flat caps. Having larger charts is excruciating.

    Another problem with the charts is that I can't specify the range easily.…

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

    For your last item, could you provide a sample workbook showing your problem?

    Thanks,
    Scott [MSFT]

  19. Error with scatter plot (aka data parsing)

    Charting as a scatter plot.
    If I have a table exactly like this:
    x y
    1 2
    I expect to plot exactly one point at coordinate 1,2. Instead I get two points even though it's a scatter plot.

    To get around this I have to make up additional points, and then erase them. I should not have to do this.

    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 →

    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]

  20. Allow dynamic selection of data callouts/labels

    I'd like to be able to say, for example, "show the label for the 2nd to last item in the series".

    Many of the dashboards I see/create pull in data on refresh and this would allow one to create better visuals that require less futzing are refresh.

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

    Interesting idea. 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]

  • Don't see your idea?

Feedback and Knowledge Base