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. Automatically assign same color to chart series with same name across different charts

    Lately I'm working a lot with pivot tables and charts. I love the ability to filter the data (rows and series) on the chart. The little draw back is that the series change color when you add or remove them.
    Actually it would be nice if the series could have a fixed color according to their name/label. It would be even nicer if the color could be preserved across different charts.
    For example if I have three regions: North, West and East, it would be nice to assign a color to a region and in every chart a series with…

    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 →
  2. Make Excel histogram compatible with normal distribution

    Dear Microsoft,
    This is more like a question. Since I'm not a mathematician but a very frequent user of MSExcel (Win 365), I have a little issue with the new histogram function. By calculating the width of the inteval by Scott's formula, I get the same value as Excel, no problem. However, I would expect the histogram to be symmetric around the average value because that is how Scott constructed the formula. Hence, the plotting of intervals should proceed from the mean value towards the left and right, according to the values of the widths of the intervals (bin widths).…

    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 →
  3. Allow to add the desired value (Unit) in Y-Axis of chart.

    During preparation of line chart I am not able to get my desired value on Y-Axis. For example if 73 and 4 are the two values (units) that I want on Y axis I cant show these two value unless I fix Major / Minor Unit to 1. So my suggestion is to add an additional Axis option to put the desired values (units) apart from fix units. Please check the attached screen shot for detail description of problem and suggestion.

    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 →
  4. 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 →
  5. Truncate chart axises

    Be able to easily truncate chart axis. This feature is intrinsic to chart design and it's hard to believe Excel still doesn't have it. The workaround methods are extremely tedious.

    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 →
  6. In the charts it would be good to be able to edit the labels on the horizontal axis manually.

    It would be good to edit the horizontal axis labels manually as sometimes only small changes are needed in a few of the labels. The option to select axis-select data-edit horizontal categories axis labels, is not very user friendly as the edit box is too small. One cannot expand it to edit the labels more clearly. In older excel versions I remember that manual editing was allowed on the labels without changing the underlying data.

    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 →
  7. Excel - increase decimal and decrease decimal Symbol

    Excel increase and decrease decimal symbol is confusing. Suggest changing left hand side arrow pointing to right. - See attached

    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 →
  8. logarithmic axises on the base of 10 which start and end in the middle of a decade

    Even Harward Graphics of the 1998th was able to show logarithmic axises on the base of 10 where the diagram starts at a position in the middle of a decade. Up tp now, Excel changes the base of the logarithm when I want to show data with e.g. 3 < x < 30. I often need a diagram between 3 < x < 30 on the base of 10, not of 3. But I dont want to have the empty area between 1 < x < 3 and 30 <x < 100.

    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 →
  9. Link Map

    Make linking options available for Map Chart Types.

    I would like to be able to link the title of my maps to cells within my workbook to make it quicker and easier to update them but it is currently not available for Maps.
    See the first note on the following link:
    https://support.office.com/en-us/article/Link-a-chart-title-label-or-text-box-to-a-worksheet-cell-efc8173a-2a8a-423b-b4e2-b10c62fca6f5

    5 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 →
  10. 3D maps data labels

    In 3D maps there is no obvious way to add labels to all the plotted data. This would usually be a data field. This is an absolute base functionality and I am astonished this is missing.

    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 →
  11. maps divided by states

    Good afternoon, I would like the map of the Bolivarian Republic of Venezuela, could be divided by state or cities, for its best representation, or if there is any way to create those divisions (city, district, parish, sector) yourself and then upload that graphic template, to be posteiorly used ...

    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 →
  12. Build a Template to show the Payoff diagram for Option Trading Strategies

    This enhancement request is to develop an interactive template in excel which will pull the data of Option Premiums from stock market exchanges and based on selection of underlying should build a payoff diagram.

    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 →
  13. Personalised maps

    Ability of drawing and naming personalised zones in Power Maps for dynamic Maps linked with Excel Tables as Gis function.

    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 →
  14. Qgis

    Making dynamic Map in excel Importing Qgis Draw map selection linked With thé Name Of Qgis map’s personalised parts.

    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 →
  15. Make the Ideas Button available in the Dutch version of Excel.

    Wellicht is het mogelijk de Ideas Button ook in de Nederlandse versie van Excel te activeren. Bij voorbaat dank.

    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. Background of Rotated Data Labels in Charts do not turn with text

    When rotating data labels in charts/graphs to 90 or 270 degrees the background and borders do not rotate with them, they remain horizontal. The only way found to manipulate this is by swapping the height and width values through VBA. Unfortunately doing that also shifts the horizontal position of the labels adding the need to further manipulate the .top/.left values in VBA particularly if the labels are of variable size.

    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 →
  17. Preserve formatting when selecting new data for a visual

    When you have a visual, and then you format it, but have to select a new dataset afterwards, excel always seems to lose the formatting. I haven't found a way around this yet but it seems like it should be fixed!

    I'm talking about when you change colors and fonts, specifically. Templates are a little clunky to use as well, even though they should help with bypassing this problem they're not helpful when all your workbooks are in OneDrive because the templates can only save to a desktop.

    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 →
  18. give more flexibility with box and whisker plots

    Please give us the ability to modify the box and whisker plots as we need to. Having them as an option is great, but the limitations on formatting, etc. make them pretty much useless. What good is a chart if we can't modify all its details to suit our data needs. Please fix this.

    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 →
  19. Intelligent options for data labels in charts

    We need better options for formatting and positioning data labels in charts.

    *better positioning options, including above left, below left, above right, below right, etc.

    *ability to specify offset (distance from data point), both horizontal and vertical

    *ability to nudge data labels with keyboard arrows

    *better number formats (see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/14817276-intelligent-number-formatting-in-chart-axes)

    *ability to display label for min or max data point, for first data point, for last data point, for every other data point, etc.

    *Tickbox option for all the data labels to match data color or some such (match the font of the data label to the line color,…

    12 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 →
  20. Pivot chart

    I greatly appreciate the possibility to use dispersion chart in pivot chart.

    Today when I need to compare numbers in pivot table I need to make pivot table and based on this the dispersion (XY) chart.

    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 →
  • Don't see your idea?

Feedback and Knowledge Base