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. When filtering a chart, provide a Clear Filter button

    I like that you can now filter a conventional chart (as opposed to a PivotChart), but a Clear Filter button at the top-left of the filter menu would be handy.

    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 great feedback. This would definitely be a good improvement. We’ll consider it for a future release.

    Thanks,
    Scott [MSFT]

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

  3. Trace dependents to graphs and names

    When I clean up others' workbooks, I use Trace Dependents to make sure that I can safely delete a value without messing up any part of the file. However, Trace Dependents does not go to graphs or names, so I have to manually check those.

    I feel that Trace Dependents should trace anything that depends on the cell being traced, not just cells.

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

    We’ll send you updates on this idea

    4 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Interesting idea. We’ll consider this in the next round of feature planning. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

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

    6 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. This is an area we are looking into improving. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  5. Add a zoom feature to charts

    In any line chart sometimes the lines are so close that we can not see the differences. Especially when we add one (or more) trend lines.

    At this point we need to zoom into the chart.

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

    We’ll send you updates on this idea

    13 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  6. Coloring chart items by referencing to fix RGB-colors

    If you create several charts in a workbook file or creating several charts in different workbooks you have to control, that a special item has the same color in any of these charts.
    In an enterprise environment this is a special need for reporting. You have to do it manually and you have to control any chart after updating because of filtering, resorting or adding new items.

    I imagine, that there could be an option button, that connects a chart to a reference file. This file can be stored locally or in an enterprise environment. The named items of a…

    26 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 →

    This is an interesting idea. We’ll consider it during our next round of planning for a future release. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  7. Scatter Charts with Group-By from third data series

    This is a basic charting function that falls in the gap between regular Scatter charts and also Pivot Charts. You should be able to plot Y against X while grouping by a third column of categories. This might be helpful in other chart types too, though is particularly vital for scatter charts.

    The question was asked here on SuperUser:
    http://superuser.com/questions/750353/excel-scatter-plot-with-multiple-series-from-1-table

    I believe it would work better for this functionality to be brought into Pivot Charts in preference to regular charts - regular charts break too easily when data changes, while Pivot charts are quick to set up and have most…

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

    We’ll send you updates on this idea

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

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

    Thanks,
    Scott [MSFT]

  9. Increase number of series from 255 to atleast 1000

    For technical or scientific data (eg band structures) we need many data series charted before narrowing down to fewer. The series limit is very annoying and has no fix except to go to open source or a different app.

    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 →

    Could you provide some additional examples or use cases where you need more than 255 series? We want to better understand the scenarios of usage.

    Thanks,
    Scott [MSFT]

  10. Box and whisker charts - log scale on y axis

    I often do stats on highly skewed data sets and use a log scale for the y axis. This does not seem to be an option.

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

    We’ll send you updates on this idea

  11. Easy method for exporting charts to other formats

    Currently it is not possible to easily export excel charts to other formats (e.g. png, eps, pdf, etc.) even in the excel 2016. The ability to do so easily (via the context menu for example) without the need to use any external software would be so handy.

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

    We’ll send you updates on this idea

    6 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Today, this can be done via a VBA macro. However, we can definitely see the value in doing this through the UI. We’ll consider this in our future planning.

    8/5/16
    We’ll be posting to the Excel UserVoice home page, the features which we’ll be implementing in the near future. To be clear though, we are focusing on features which have the highest customer interest which typically have hundreds of votes.

    Thanks,
    Scott [MSFT]

  12. Include ThinkCell add-on waterfall chart capabilities into Excel charts

    ThinkCell Waterfall add on to Excel https://www.think-cell.com/en/support/manual/waterfall.shtml has more business capabilities comparing to Excel own waterfall chart.

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

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  13. Do not chart null values

    Chart defaults to plotting null or ' values as zero. The default should be to not plot null values

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

    We’ll send you updates on this idea

  14. Quick add vertical or horizontal bars with a given value to a chart (aka reference lines)

    Common things that are very hard to do in Excel, should be easy to do and most people implement by drawing with a shape instead of using Peltier's workarounds:


    • Add a vertical/horizontal line at a given value. Could be linked to a range. Could have a legend.

    • Add a vertical/horizontal line at the selected datapoints' value.

    • Add a vertical/horizontal line at the last series' point value.

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

    We’ll send you updates on this idea

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

  15. Timeline slicers do not show the exact date range present in the data

    the timeline slicer do not show the exact range of the dates present in the data. instead , it shows the entire year.

    For example: i have a dataset from the month of Dec-2015 to Mar-2016. when i insert a timeline slicer, it displays two complete years (from Jan-2015 to Dec-2016) .

    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 →
  16. Data Labels disappearing from charts

    This is a real problem !! When you refresh a picot chart the Data Labels either totally go away or some of them do... It's inconsistent .

    This same problem was inherited by the Web version btw.

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

    We’ll send you updates on this idea

    7 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  17. Paste Excel charts into Word as EMF by default (not big blurry PNG!)

    Charts pasted to Word as Enhanced MetaFile look better and are much, much smaller that the PNG files generated by default. This has consequences for PDF exporting. A Word report with more than a couple of charts ends up as a multi-megabyte PDF file, when using EMFs yields files in the low hundreds of kB. Please add an option in either program to use EMF as the default format.

    21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 feature suggestion. We’ll definitely consider changing this default. Please continue to vote on this feature idea which will increase its chance of getting in the product.

    Thanks,
    Scott [MSFT]

  18. Enable better control of treemaps

    Done right, Treemaps are a generalization of Marimekko plots. But, we need to be able to control the maps. E.g., control whether a level-one group stretches thinly from the bottom to the top versus being more square and stacked under another level-one group. Also, labeling has to be better--you should at least meet (if you can't exceed) the features in Jon Peltier's add-in.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. We’ll consider this in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  19. Add "recession shading" or dates highlighting to charts (aka Banded regions)

    It's cumbersome to add "recession shading" or period highlighting to a chart (see Peltier's method: http://peltiertech.com/highlight-certain-time-periods-in-a-chart/), but it is very common feature in time series economic analysis, and most people just don't bother, draw a transparent rectangle over the chart and align it manually.

    Please add a range highlighting option for charts with a date x-axis.

    22 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 →

    This is great feedback. Supporting this feature is something we are actively discussing. Please continue to vote on this feature suggestion which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  20. Excel Treeview - VBA Control

    The new TreeView in Excel 2016 is great, however, code-base manipulation via VBA seems to be absent. Specifically looking to change the colors for each of the squares, or at least control how the chart defines its color base.

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

    We’ll send you updates on this idea

  • Don't see your idea?

Feedback and Knowledge Base