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

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

  3. Improve the precision of object placement on charts

    Since Excel 10, the precision of placed objects like lines on charts has deteriorated. For example, drawing a 45 degree line on a chart from one corner to the other is very imprecise because it seems the cursor has trouble picking up the correct pixel in the chart axes corner. Sometimes the chart has to be resized to nail the placement down.

    1 vote
    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. Would you be able to provide a sample file that illustrates the problem or more specific repro steps?

    Thanks,
    Scott [MSFT]

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

  5. Axis title high-low option for charts.

    For some unknown reason, excel chart always flips my data so that the first data point is at the bottom of the y axis. As a result, I always have to select 'reverse order' so that the data appears in the order that I type it. Annoying, but not a major problem. However, the x-axis title is now always at the top, and there is no option to select 'high' to place it at the bottom of the chart.

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

    I’m not able to reproduce the problem you are describing. Can you send me more explicit steps that are needed to reproduce it and a sample file?

    Thanks,
    Scott [MSFT]

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

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

  8. Discriminator values to color cells

    Allow values to be used as color discriminators for scatterplots. Identify a column of values and specify a number of bins to base the colour discrimination. Change the colour for each bin and allow each bin to be a seperate series so that regression lines can be drawn.

    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 →
  9. Pre-formatted templates for data visualisation (e.g. tables, charts)

    I see this as a modernisation, ease of use of good old excel for people who are not advanced users, or people who don't have time or many people who only need basic features - e.g. tables and (related) charts.

    I love the idea I could just dump data and instantly have a nice outcome/visualisation, potentially in a box, so I could see the template coming alive as I dump/amend data.

    To wrap up, all the user would need to do is to copy/paste data to populate the fields for the templates. No further action required from users, no need…

    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 idea. I just want make sure I understand it. Are you suggesting that we automatically create a chart when data is put in the grid? If not, is there an example you could provide?

    Thanks,
    Scott [MSFT]

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

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

  12. Add a Normal Probability Axis Option to Scatter Charts

    A normal probability axis, including cumulative probability option, would be wonderful. Have the option to format the axis labels as decimal, percent, or 1/p. Currently we have to add many series to represent gridlines, add text boxes for axis values, and get new series values using NORMSINV to chart on a probability scale.

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

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

  15. FIX: Changing formats for one data label/callout impacts other lables/callouts in the same series

    As is (in Excel 2013), when you want to change a label, often times, you end up also resetting the other labels as well.

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

    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 →

    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]

  17. Filter in the Data Table below a chart

    Make it able to hide rows/columns with a filter option in the "Data Table" with chart data that can be added to a chart.

    1 vote
    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 further details. We’ll evaluate this for a future release. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

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

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

  20. Charts - Decomposition Trees

    Please add Decomposition Trees as a standard chart type : http://bit.ly/1GLL4hH

    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 →

    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]

  • Don't see your idea?

Feedback and Knowledge Base