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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Power Query - cache shared nodes

    Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).

    This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.

    1,116 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      113 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
    • Adding comment (tool tip) in chart (to various elements of the chart, data points, etc.)

      To be able to add comments to a specific data labels in a chart (can be bar chart, line chart)

      18 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        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 an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.

        Thanks,
        Scott [MSFT]

      • Tighter integration with MS Access

        Tighter integration with MS Access - improve (expand) object model to provide more powerful and transparent integration between Access, Excel and Word. Make it easier to create visual models using flexibility of Excel column / Row structure using MS Access datasets and VBA code.

        11 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          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 future planning. Please continue to vote on this idea.

          Thanks,
          Scott [MSFT]

        • Better compatiity with the Surface Pen

          With the surface pen, users should be able to write in any cell on a spreadsheet and excel will automatically convert the handwriting to digital numbers or letters when the user starts writing in a different cell (or maybe after users draw a special characters like a check mark or something like that to signal to excel that the user is done writing in that cell.)

          12 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            2 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

            Cool idea. We have been exploring a number of pen ideas like this for Excel. We’ll definitely consider this one in our next round of planning. Please continue to vote on this feature idea.

            Thanks,
            Scott [MSFT]

          • Linking chart title to a cell on waterfall charts.

            How can I link a cell as Chart Title for waterfall charts.

            7 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

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

              This capability is not currently supported on any of our new chart types in O16. However, we are working on plans to support this functionality in the future.

              Thanks,
              Scott [MSFT]

            • 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

              3 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
              • 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.

                2 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  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]

                • 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…

                  8 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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.

                    4 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      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]

                    • 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)

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        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 functionality that we are in the process of designing right now.

                        Thanks,
                        Scott [MSFT]

                      • Python as an Excel scripting language

                        Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

                        3,133 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          212 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

                          HI folks,

                          Thanks for the continued passion around this.

                          We’ve been busy building an infrastructure that allows remote execution of arbitrary code from custom functions in Excel. This was introduced last week at the Microsoft Ignite conference with Azure Machine Learning (https://azure.microsoft.com/en-us/blog/tools-for-the-ai-driven-digital-transformation/), which itself can host code in various runtimes.

                          This is just the beginning, and doesn’t cover many of the scenarios this user voice item now has. Just wanted to drop a quick note saying we’re continuing to work to deliver the scenario we announced with high quality and explore other integration points.

                          Thanks again

                          Ashvini Sharma,
                          Lead Program Manager
                          Microsoft Excel

                        • 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

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                          • 4 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              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]

                            • Embed 3D maps in worksheets

                              Add the ability to embed 3D maps within an excel sheet. If you are making an excel-based dashboard, it would be great to have the capability to showcase the map right within the sheet instead of as a pop-out visual.

                              13 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                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 input. We’ll consider this in our future planning efforts. Please continue to vote on this idea.

                                Thanks,
                                Scott [MSFT]

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

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  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]

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

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Waterfall

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

                                    2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      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]

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

                                      2 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        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]

                                      • Excel 2016 Waterfall Chart ...Enable Save as Template setting

                                        Enable the Save chart changes (e.g. Colurs on Waterfall) as Template for Waterfall. This is enabled for other Chart Types but not for Waterfall.

                                        11 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          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 your input. This limitation is true for all of the new chart types released in Office 2016; e.g. waterfall, histogram, treemap, etc. This is functionality we are assessing to enable for the new chart types. Please continue to vote on this feature idea.

                                          Thanks,
                                          Scott [MSFT]

                                        • 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…

                                          2 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            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]

                                          ← Previous 1 3 4 5 6 7 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base