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. Semi Average Regression Line

    Hey
    I have to create a semi average regression line my school project . I have no idea how to create one on my own. Could you please put this line as one of the trendlines on excel?
    Much appreciated

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

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

    Thanks,
    Scott [MSFT]

  3. 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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

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

    Thanks,
    Scott [MSFT]

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

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

  8. 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 →
  9. 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]

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

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

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

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

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

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

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

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

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

  19. 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 →
  20. MODE function work for text

    Could you make the MODE function work for text?
    Currently you have to do a crazy index and lookup thing, which could all be made so much easier if mode worked for text. i.e., if you have MODE("a", "b", "c", "a") you would get "a".

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base