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. Countif(search("string",array)=true)

    Allow countif (and countifs) to count cells where I am searching an array for a string value. For example, if I have a table with dates in one column and names in another column, but I may have multiple names in a single cell, I want to be able to count the number of cells that have John listed even if that cell also has Jane as a value.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Network functions, like ping() or nslookup()

    Handy if you have a column of hostnames or IP addresses.

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Interesting idea, thanks for the suggestion. I’d be interested to know if there are other functions in this area that people also want to see. I’ll check back soon to see how many votes this is getting, so if you like the idea be sure to vote for it.

    Cheers,
    John [MX XL]

  3. Bullet charts

    Pls add support for bullet charts

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

    Thanks for the further details on Bullet charts. The Wikipedia article is a good reference. As we plan the next release, we’ll definitely consider this new chart type.

    Thanks,
    Scott [MSFT]

  4. Lockable aspect ratio in charts.

    It would be handy to be able to lock the aspect ratio of a chart. I specifically use scatterplots to display a visualization of land surveying points as a check that data entry was correct. Because UTM coordinates are so large and the extent of the survey points changes with every entry the chart continually resizes.

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

    When you say the “chart continuously resizes” are you referring to the chart’s value axis scale? The physical boundary of the chart should not resize when the data is added. When a chart is inserted, the default size is 3″×5″ which doesn’t automatically change but the user can manually change it through the Format ribbon or resizing the chart via its drag handles.

    Thanks,
    Scott [MSFT]

  5. Allow all charts to be animated using a time field - perhaps via timeline slicer

    Extend the ability already in Power View and 3D Map/Power Map to 'play' all charts using a time/date field. The Timeiline Slcer looks as though it could be an ideal way of doing this - just by adding the ability to play through the selected time increments in the Slicer.

    9 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. We are exploring the possibility of adding a time playback axis to all native charts in a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  6. Colour between lines on chart

    This is typically appropriate between a min and max on the same data-set, so as to show the range in which values occur.

    Another use-case is to draw a phase diagram: https://stevengoddard.files.wordpress.com/2010/09/water-phase-diagram1.jpg?w=450&h=420&h=420

    There's a workaround to do this for standard charts here, though it's tremendously cumbersome: http://peltiertech.com/fill-under-between-series-in-excel-chart/
    It produces a chart looking like this:
    http://peltiertech.com/images/2013-09/OverlapCharts.png

    I'm more interested in this for PivotCharts where we often look at min, mean, max lines for data together. It would be great to be able to shade or colour between them.

    PS: Even to make a min line and max line of the same…

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

    Good feedback. We’ll roll this into our plans for new features that we are considering for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  7. Chart Feature: Dynamic Legends

    Instead of fixed legends, please allow the user to create a dynamic legend, so that if there are no values for a particular category, the legend does not show up for that category.

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

    We’ll send you updates on this idea

  8. Make find and replace work in charts for easier formula editing

    Find and replace should work with charts too, both with text shapes and with the series' formulas. This is a major time saver for editing many series' at once.

    Jon Peltier made an addin that implements this: http://peltiertech.com/change-series-formula-improved-routines/.

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

    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]

  9. MODE function work for text

    Could you make the MODE function work for text?
    Currently you have to do a crazy index and lookup thing, which could all be made so much easier if mode worked for text. i.e., if you have MODE("a", "b", "c", "a") you would get "a".

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add a 'Series Description' option when creating a series for a chart.

    Add a 'series description' option when creating a series. Then when adding the legend you can select to use the series name or series description as the legend. Would be useful when using data labels that need the series name shortening in some graphs - the legend then acts as a key

    6 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 planning for a future release. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  11. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

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

  13. Adding a scroll bar as a default option in excel charts

    It appears when the range of data in a chart is huge, providing a scrollbar can be a handy option to scroll through big data in a user friendly way (without going through sizing -resizing again). If you can provide this option with charts (and thus in VBAs), it will be a handy feature to work with !
    Cheers, Pramod

    3 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 and further clarification. We are currently exploring a number of interactive features like this. We’ll keep this one in mind during our planning process. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT}

  14. Animation in Excel Charts just like PPTs

    In corporate world generally powerpoint presentations are used because they give option of animations.

    in excel it is possible to do with VBA (to some extent) but still its very hard.

    If it could be made possible to give animations in Charts/ areas (A1:G7) / Name ranges, it would be very useful for presenting data.

    thanks for the forum. its really great. :)

    Regards
    Sarvesh Prasad

    5 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 the next round of planning. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  15. Automatic labeling for scatterplots

    Please provide a way to add labels automatically to scatterplots. It would be great if you could add a third dimension of data that would be text labels for scatterplots.

    9 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 suggestion. We are looking at ways to do this labeling automatically.

    In the meantime, we did provide a way to do this in Excel 2013 but it requires a few steps.

    1) Turn on “Data Labels” for your scatter chart
    2) Open the “Label Options” in the task pane. This can be done by double clicking on one of the data labels.
    3) Check the box called “Value From Cells”. Then select the range that contains the labels for each data point.
    4) Turn off the other extraneous labels in your data label from the “Label Options” task pane.

    Please give this a try and continue to vote on this feature request (e.g. automatic labeling) which will increase its likelihood of getting into the product.

    Thanks,
    Scott [MSFT]

  16. Total least square fitting on graphs & Deming regression in line-of-best-fit functions

    Least squares fitting only minimizes the error in dependent variables. The error in the independent variables is ignored.

    For the graphing of any data obtained by measurement, such as in science, we should consider the error in all variables, and so we should have an option to plot curves of best fit based on total least squares fitting.

    It would also be nice to have an option to specify Deming regression in some of the line-of-best-fit-related functions such as SLOPE, INTERCEPT, FORECAST, LINEST, TREND, PEARSON, and RSQ.

    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. We’ll consider this in our next round of planning. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  17. Charts and Graphs UI

    1) Allow multiple data labels/ bars to be selected simultaneously for editing/formatting or movement
    2) Allow a specific data point/ bar of a chart to be used for individual hyperlinking

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

    We’ll send you updates on this idea

  18. Custom tool tips for charts

    I would like to have custom tool tips for a chart. I have hidden the x axis labels and added some data labels and would like the tool top to display the data label text instead of the x axis label text. I have exported the chart from a vb.net winform app but have been told that this currently isn't possible and advised to post on here!

    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 →

    Good feedback. We’ll consider this in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  19. List all charts and their series in a Task Pane with quick search for easier navigation

    Big Excel files with lots of sheets are hard to navigate. Excel could do with a tree view task pane with a search box showing each charts' sheet name, its title and the series it contains. Then you could click on a series and go directly to that chart. Maybe it could also show (if so chosen by the user) a thumbnail of each chart. It doesn't need to be a live rendering of the chart to be useful. Right clicking on each series would also reveal a menu with options like: go to the X values range, go to…

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

  20. Cannot open files saved after assigning graph series values names that use structured references

    Since graphs series cannot contain formulas, if you want to make a graph dynamic, you must use a name (in the Name Manager sense) that contains a formula that determines the dynamic range.

    However, if that name uses structured references, then when you save and reopen the file, Excel will crash and the workbook will be unusable to Excel.

    To see what I mean, download this workbook:
    http://www.mediafire.com/view/a2681miflhdjxep/Graph_Crash.xlsb
    Right-click on the graph and go Select Data. Edit Series1 and change its series values to read "=s!y" (without quotes). Save, close, reopen, crash.

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

Feedback and Knowledge Base