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. Render texts with DirectWrite, or give us a choice

    DirectWrite is good for hi-res screens while traditional Cleartype is good for low-res screens. Hi-res screens are the trend. Give us hi-res screen owners a choice to dive into the world where every character is super clear.

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

    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 in our next planning phase. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

    What type of deeper integration for charting are you looking for? Currently, most of the UI is shared and they use the same charting engine.

    Thanks,
    Scott [MSFT]

  4. Allow me to geocode up to 25 locations 3D Maps

    Please all us to bulk load at least 25 locations in the "Find" locations in 3D Maps. Allow us to upload a spreadsheet and have Bing kick back the lat/long and location info. Looking up lat/long is time-consuming

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

  6. Improve Data Visualization (Analytics) and/or Charting options -- thus making EXCEL the defacto app.

    Improvement should include more options (including 3D) than presently available -- bringing more up to par with other offerings (such as Tableau, Prezi, etc.)

    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 →

    This is a very broad statement. Please provide additional details on the specific features that you would like to see. Ideally log those as spate feature requests so that others can vote on them individually.

    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. provide new chart type: Turnip Chart from Dartmouth Atlas; I have sas code that does it

    provide new chart type: Turnip Chart from Dartmouth Atlas; I have sas code that does it

    SAS Code

    %let gpath='.';
    %let dpi=200;

    data mydata;
    format percent percentn9.2;
    format cumpercent percentn9.2;
    input mpg freq percent cum
    percent;
    percent=percent/100;
    cumpercent=cumpercent/100;
    Cat='A';
    datalines;
    11.57101 2 2.70 2.70
    13.88521 8 10.81 13.51
    16.19941 8 10.81 24.32
    18.51361 17 22.97 47.30
    20.82781 8 10.81 58.11
    23.14201 12 16.22 74.32
    25.45621 8 10.81 85.14
    27.77042 3 4.05 89.19
    30.08462 4 5.41 94.59
    34.71302 3 4.05 98.65
    41.65562 1 1.35 100.00
    ;
    run;

    /--Expand the data--/
    data expand;
    set mydata;
    do i=1…

    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. Create unique object names by worksheet

    Charts and other drawing objects don't have unique names. To illustrate, we could have a dozen charts on a worksheet, all named "MyChart".

    These duplicate names make it difficult for VBA and any other programs to work with drawing objects, including charts.

    Excel should enforce unique object names by worksheet.

    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 →
  10. Chart gridlines on top of series as option

    Allow users to optionally select which 'layer' of a chart the gridlines sit. eg, I have an area chart to show a target, with a line of actual performance over it. I would like the gridlines to show over the area layer of the chart, but sit behind the lines.

    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. This is an interesting idea. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  11. 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 →
  12. Allow left and right vertical axes to sync their gridlines

    Suppose we have a left and a right vertical axis. One axis could have, say, five labels and tick marks, and the other could have seven. But there's no way to synchronize those items so that their gridlines can overlap.

    To implement this, you could offer a check box that would synchronize the two axes, or you could allow us to specify the number of tick marks on each axis so we could synchronize them ourselves. Better yet, you could offer both options.

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

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

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

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

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

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

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

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

  • Don't see your idea?

Feedback and Knowledge Base