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.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## Sankey diagram

Can we please have this type of chart as a main feature. I mean is so useful for a lot of things. is just so intuitive. so is perfect for representing all sorts of data that change in time and also that show the components of something bigger. broadly speaking I thing you should rethink the all chart sections because I think can be improved. I mean is the same for as far as I remember it.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Add charts that animate over a range of values

I would like to create a chart that dynamically changes to show values over time. Consider the simplest pie chart showing a single percentage value of something... One wedge out of the 100% circle. Now assume I have two columns of data: One showing a year and the other showing the corresponding data percentage for that year. I would like to be able to create a pie chart that lets me move the year value forward and backward, showing the corresponding wedge changing size to match the percent for that year. The visual display is a single chart object that…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## Step Graph

Please add the option to create a step graph as a type of line graph. This is a different way of presenting the data and in certain cases is a much more useful visual representation.

I have found workarounds to create a step graph but only if the data uses dates as the horizontal axis. I need to be able to create a chart with \$ amount (for example) as the horizontal axis and have it be a step graph.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## capture data from picture of chart

Now that the ability to get data from a picture (of a table or text), can we extend the capability to grab data from a picture of a chart?

My clients often send me screenshots of charts and ask me to put them in presentations. Usually this means the chart doesn't come close to matching the presentation, and I cannot change the font or data color, the font size, etc. So I must recreate the chart. This can be painful.

There used to be an add-in called Grabit that added the image of the chart to a spreadsheet, prompted us…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## BUG: Stop 'Paste Formats' Overwriting Non Pivot Chart Data Source When Copying from PivotChart

I create a new chart with a new data source (non pivot table based), and want the formats from an existing chart to be used. However copying the existing chart (pivot table based), then selecting the new chart, selecting Paste Special: Formats, overwrites the actual data source of the new chart to the same as the old. Worse still, if you press undo, Excel forgets the original data source and unlinks the chart completely, so you need to redefine the data source, AND manually set the formats to match the preferred chart style. Please fix!

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## The online templates available are SOOO old and outdated looking majority of the time, when can you start providing more current tables and

I'd love to assist in designing newer more modern looking charts for your galleries! They are always so old and outdated looking when I search for projects. LOVE using excel still, and Microsoft Suite!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## Display organized many sheets

Display organized many sheets

In order to be able to manage many sheets I suggest to make groups of sheets that allow the choice of the sheet to be displayed via pop-up

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Allow Source Change for Pivot Charts

Allow users to change the Chart Data Range to another pivot table. This will allow users to continue their "flow" of data exploration without having to either 1. overwrite their last pivot chart analysis or 2. break flow by re-generating the same visual but with slightly different inputs. It's also more natural than saving the chart template.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Kastengrafik

In der deutschen Version von Excel 2016 ist die Diagrammvorlage 'Kastengrafik' nicht wirklich sinnvoll nutzbar, da sie keine Spalten-bezogene Beschriftung der Rubrikenachse zulässt.
Das Problem lässt sich nur mit der bereits im Excel 2013 nutzbaren Variante über den 'gestapelte Säulendiagramm'-Umweg lösen.
(siehe angehängte Datei).
Außerdem wäre die Bezeichnung 'Box-Whisker-Plot' für die Vorlage
intuitiver.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## bug in points diagram

I believe there is a bug in data handling for a scatter plot (points diagram), when there are empty or pseudo empty cells in the data range: The diagram pretends to be a points diagram, and the data ranges are correctly defined. Nevertheless, the diagram does not show the X data on the horizontal axis, but their index. This should not happen, because it can lead to severely wrong conclusions! This came up in teaching. (The data in the file have been downloaded from a public website and thus are neither mine nor confidential.)

I would appreciate a fix.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Conditional formatting tables

Conditional formatting in tables, at the moment, attempting to apply conditional formatting to a table causes the document to become incredibly unstable especially as the database size grows. It's also incredibly unwieldy.

Conditional formatting in general should probably be updated to be more dynamic and consistent with other aspects of Excel, it doesn't appear that conditional formatting has changed much since much earlier versions of Excel.

PivotTables also automatically break conditional formatting of entire rows or columns of data. It would be nice to be able to apply conditional formatting dynamically to rows of data in PivotTables.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Graphically show alignment for objects (e.g charts)

If you have ever used Google Sheets and had to align multiple charts you will know exactly what I am referring to and if you have not you should go try it to see how easy it is. Excel should replicate the same thing.

For those unfamiliar see the attached screen print. Basically when there are more than 1 chart and you drag 1 of the charts it will visually display when charts are aligned (top, bottom, left, right, center) and it will align the gaps between multiple charts to get the spacing even.

It is soooooo easy compared to…

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Please Update Data validation List UI.

If we type on the cell that have data list then it should appear suggestion in drop down list like excel phone app

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Please Update Data validation List UI.

If we type on the cell that have data list then it should appear suggestion in drop down list like excel phone app

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## I am trying to combine two excel data tables on one graph

I need the population and type of drug on the x-axis and the percentage on the y-axis showing the differences between the two sets of data

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## highlight cells with find tool

When using the find tool it now barely outlines the cell. The old excel would highlight it so it was obvious which cell was found. Now it just puts a dim green line around it making the find tool MUCH less helpful than it used to be. A glaring step back on the newer excel making it less useful than previous versions.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Chart colors to match data font/cell colour

It would be great if there was an option to have the colour of a data series in a chart match the colour of the data it was referencing (either the font or the cell colour). This would make changing the colours in the chart much quicker, especially in cases where you would like different colours for different parts of a single series.
This could also work with Conditional Formatting.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Zoom tool for graphs

Excel is great for quickly plotting and looking at data. But it falls short when the user wants to view a specific region in a graph or chart. The only way I know how to do this is to change the axes to 'force' zoom-in on a region, which is very clunky and slow. It would greatly improve the users ability to look at specific regions of the data quickly if there was a zoom in/out tool (similar to MATLAB's implementation) in the side toolbar that appears when hovering over the chart. Additionally, having a hand tool that, when zoomed…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Add "Invert if negative" option for Area charts

Please add a "Invert if negative" option for Area charts, similar to the one we have for the Bar charts.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Round off and number formats in data labels

It should be possible to format the data labels with regards to number format and the number of digits.

1 vote