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 inapp 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 thirdparty 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.

Improve graph creation and customization
When graphing it's a nightmare to make something with error bars or to create a good legend ... etc. Please make it possible to insert a group as a single value for a bar chart. Select the group, ask the chart to display the mean (or median or whatever statistic), and from there ask it to display error bars and so on.
Speaking of error bars, I think it's necessary to add the option of changing the width of the flat caps. Having larger charts is excruciating.
Another problem with the charts is that I can't specify the range easily.…
6 votesThanks 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.
For your last item, could you provide a sample workbook showing your problem?
Thanks,
Scott [MSFT] 
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
Rightclick 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 votesWe’ll check into this crashing issue. The following bug number is tracking this issue: 2762327.
Thanks,
Scott [MSFT] 
Insert an image directly from a scanner
In order to insert an image from hardcopy material it is necessary to scan the material to a graphic file and then insert the graphic. It would save time and effort to insert an image directly from a scanner. For example, I scan invoices and cash register receipts from individuals to insert into a voucher for authorization to cut a check for reimbursement to the individual.
6 votesThis is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.
Thanks,
Scott [MSFT] 
Enable Variwide / MariMekko charts
Hi, I use Variwide or Marimekko charts quite frequently and find this to be a major pain in Excel. There are ways to work this in using Area charts and additional rows and formulas for formatting, but it takes a while. Further, it often doesn't allow a linear chart based on my values unless I change the axis to dates, and cheat the formatting to show non date numbers...
It would be great if this could be built in, or at least be made easier (by not having to change the xaxis to dates)
(20151105 Dan [MS] recategorized to Charting)
5 votesThanks 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 also further comment on the specific features of a MariMekko chart that you would like to see?
Thanks,
Scott [MSFT] 
Charts  Decomposition Trees
Please add Decomposition Trees as a standard chart type : http://bit.ly/1GLL4hH
5 votesThanks 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] 
Option to automatically resize a pivot chart to show all labels as slicers change
Pivot Chart option to auto resize to show all labels as slicers change the data
10 votes 
"Comment" window double as container for Chart or visual data Analytics object
The cell 'comments' window should double as a container for 'simple? ' visual data analytics objects, charts, or BI visuals. For example if I had a column or row of numbers
row 1  3, 5, 6, 7
row 2  4, 6, 9,10
I would like to click in an area in either of the last numbers of either ranged row of numbers and a popup visual chart view of the data would appear. Chart Labels could be created in the Data Validation window just as lists are made.3 votesInteresting idea. 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] 
Allow dynamic selection of data callouts/labels
I'd like to be able to say, for example, "show the label for the 2nd to last item in the series".
Many of the dashboards I see/create pull in data on refresh and this would allow one to create better visuals that require less futzing are refresh.
2 votesInteresting idea. 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] 
Chart alignment
Make it possible to select the chart xaxis to auto align or always align to zero or always zoom only on the data somewhere in the y axis.
6 votes 
adding picture to excel spreadsheet
adding graphs from other sites that would usually fit in a word document to an excel document. Or the ability to attach a word tab to an excel document.
4 votes 
Semi Average Regression Line
Hey
I have to create a semi average regression line my school project . I have no idea how to create one on my own. Could you please put this line as one of the trendlines on excel?
Much appreciated4 votesThanks for the feedback. We’ll consider this in a our planning for a future release.
Thanks,
Scott {MSFT] 
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 votesInteresting idea. Thanks for the feedback. Please continue voting on this feature idea.
Thanks,
Scott [MSFT] 
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.WorksheetWorkbooks.Add
Set lcWS = ActiveSheet
With lcWS
.[a1] = "Time": .[b1] = "Left1": .[c1] = "Left2": .[d1] = "Right1": .[e1] = "Right2"
.[a2] = "0:00:01": .[b2] =…2 votesThanks for the feedback. We will check into this issue.
Thanks,
Scott [MSFT] 
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 45degreeline tick mark on the upper right side of the symbol.
6 votesThanks for the additional details. We’ll consider this in our future planning. Please continue to vote on this feature idea.
Thanks,
Scott [MSFT] 
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 votesThanks 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] 
Cortana should learn excel syntax so that I don't have to
Cortana should learn excel syntax so that I don't have to. Pretty simple, for users that don't want to learn functions such as left/right, they should simply be able to say "Cortana, take the last 3digits off that column and put them in the next column" "Make me a pie chart with the colors red white and blue"
(20151105 Dan [MS]  added to Formulas and Functions category)
8 votesThanks for the post. As always, we’ll be looking at ideas in priority order according to the number of votes things have. So please keep voting for things you want to see done sooner!
Thanks
John [MS XL] 
Error with scatter plot (aka data parsing)
Charting as a scatter plot.
If I have a table exactly like this:
x y
1 2
I expect to plot exactly one point at coordinate 1,2. Instead I get two points even though it's a scatter plot.To get around this I have to make up additional points, and then erase them. I should not have to do this.
3 votesThanks 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] 
When altering a graph have an option to see the updated graph only after the settings window you had open is closed.
For example when adding multiple data series to a scatter plot the graph is updated after each series is added. It can take a long time to add a new series after a few have been added, when using large amounts of data points. I suggest something like what photoshop does which allows you to disable updates until the current settings window is closed.
I have found a work around. If you place the graph in excel so you can't see it and click "Formatselect data" you can plot as many series as you like without lag since it is…
3 votesThanks 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] 
Convert freeform shape to plot via x,y points
I would like to draw a freeform shape using the drawing tools, and then apply a tool or function that allows me to replicate the shape in an xy plot. I found some VBA code online that lets me find the vertices of said shape, and I can plot those vertices in an xy plot, but it comes out as some sort of weird approximation. It reminds me of when you use Google translate for a phrase into one language, and then you translate it back.
2 votesCool idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.
Thanks,
Scott [MSFT] 
From a chart's series to x/y values range with a right click menu option
Consider adding these options to a selected series' or datapoint context menu:
. Go to the X values range
. Go to the Y values range
. Go to the series name range
. Extend/contract series range by n cells.I've actually implemented all of this for my own use in VBA, with keyboard shortcuts. So Alt+Right extends every range one cell, Alt+Shift+Right extends every range 20 cells, Ctrl+i in a chart takes me to the X values range (or cell, if a single data point is selected). HUGE time saver.
2 votesThese are interesting ideas. 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]
 Don't see your idea?