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. "Comment" window double as container for Chart or visual data Analytics object

    The cell 'comments' window should double as a container for 'simple? ' visual data analytics objects, charts, or BI visuals. For example if I had a column or row of numbers
    row 1 - 3, 5, 6, 7
    row 2 - 4, 6, 9,10
    I would like to click in an area in either of the last numbers of either ranged row of numbers and a pop-up visual chart view of the data would appear. Chart Labels could be created in the Data Validation window just as lists are made.

    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 →

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

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

    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 →

    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]

  3. Chart alignment

    Make it possible to select the chart x-axis to auto align or always align to zero or always zoom only on the data somewhere in the y axis.

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

    We’ll send you updates on this idea

  4. adding picture to excel spreadsheet

    adding graphs from other sites that would usually fit in a word document to an excel document. Or the ability to attach a word tab to an excel document.

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

    We’ll send you updates on this idea

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

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

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

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

  13. When altering a graph have an option to see the updated graph only after the settings window you had open is closed.

    For example when adding multiple data series to a scatter plot the graph is updated after each series is added. It can take a long time to add a new series after a few have been added, when using large amounts of data points. I suggest something like what photoshop does which allows you to disable updates until the current settings window is closed.

    I have found a work around. If you place the graph in excel so you can't see it and click "Format-select data" you can plot as many series as you like without lag since it is…

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

  14. Convert freeform shape to plot via x,y points

    I would like to draw a freeform shape using the drawing tools, and then apply a tool or function that allows me to replicate the shape in an x-y plot. I found some VBA code online that lets me find the vertices of said shape, and I can plot those vertices in an x-y plot, but it comes out as some sort of weird approximation. It reminds me of when you use Google translate for a phrase into one language, and then you translate it back.

    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 →

    Cool idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  15. From a chart's series to x/y values range with a right click menu option

    Consider adding these options to a selected series' or datapoint context menu:
    . Go to the X values range
    . Go to the Y values range
    . Go to the series name range
    . Extend/contract series range by n cells.

    I've actually implemented all of this for my own use in VBA, with keyboard shortcuts. So Alt+Right extends every range one cell, Alt+Shift+Right extends every range 20 cells, Ctrl+i in a chart takes me to the X values range (or cell, if a single data point is selected). HUGE time saver.

    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 →

    These are interesting ideas. 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]

  16. Spellcheck should include text in linked pictures from other sheets

    My clients produce master spreadsheets containing sections of text as linked pictures from other sheets in the same files. After processing the master spreadsheet, I do a spellcheck, which tells me "Spellcheck complete. You're good to go." But I'm not really, because spellcheck doesn't look at those linked pictures. I only just discovered this. Now I have to spellcheck each sheet separately. Either make spellcheck work properly, or at least provide a warning of what hasn't been checked.

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

    We’ll send you updates on this idea

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

    Thanks for the feedback. We’ll consider this in our planning for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

    We’ll send you updates on this idea

  18. VBA: add a TAG property to the Chart object

    A chart in a worksheet has a name, the only way to identify the chart in VBA is to use the shape name.

    But when the user moves the chart to an other sheet and back, the name of the chart changes! I understand that it is necessary that the name changes, but at this point we can not identity the chart anymore.

    So a TAG property (same as in ActiveX controls) would be very helpful to find the right chart within a macro.

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

    We’ll send you updates on this idea

1 2 3 4 5 7 Next →
  • Don't see your idea?

Feedback and Knowledge Base