Jon Peltier
My feedback
-
4 votes0 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
38 votes14 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
shared this idea
·
-
1 vote2 comments · Excel for Windows (Desktop Application) » 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] -
32 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
38 votes12 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
11 votes1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
7 votes4 comments · Excel for Windows (Desktop Application) » 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 feature idea.
Thanks,
Scott [MSFT]Jon Peltier
supported this idea
·
-
10 votes2 comments · Excel for Windows (Desktop Application) » 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]Jon Peltier
supported this idea
·
-
30 votes7 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
14 votes3 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
49 votes6 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
20 votes5 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
43 votes4 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
98 votes8 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
5 votes1 comment · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Jon Peltier
commented
This functionality has existed in Excel for a very long time:
If you hold down the ALT key while moving or resizing a chart, or any shape in Excel, the edge of the chart will snap to the cell boundaries.
-
8 votes3 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
15 votes4 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Jon Peltier
commented
I voted to give this suggestion visibility. But I have reservations any time there is a chance that Excel will override something I'm trying to do on purpose. Couldn't chart number formats have a "literal mode" (what I've told it) and also a "smart mode" (what Brad is suggesting here)?
There are other weaknesses in the ability to apply number formats to charts. For example, there are not the spinner buttons to increase or decrease decimals that we have in the Format Cells dialog, and the Number group on the Home tab is disabled for charts (WHY? A confusing subset of the Font and Alignment controls on the Home tab are enabled for charts). Also, in the Format Cells dialog, you can insert a line feed into the format by pressing Crtl+J, which is totally undocumented but has been around since the Stone Age. This format is good for displaying month and year, or month and day, on separate lines, and is arguably more useful in a chart than in a cell. However, you can't enter Ctrl+J in the Format Code box in the Format Chart task pane; you can copy a line feed character from somewhere else (NotePad?), but that is seriously tedious.
Jon Peltier
supported this idea
·
-
745 votes
Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
Jon Peltier
supported this idea
·
Jon Peltier
commented
Microsoft has clearly stated in many places that the VB editing capabilities in Mac Excel 2016 are still under development. I don't like the VB Editor in Mac Excel 2011, so I do all my VBA work in Windows, then just use Mac Excel 2011 and 2016 for testing and debugging, and implement any changes needed in Windows.
-
30 votes1 comment · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Jon Peltier
commented
This is a great idea, and removes the requirement for the user to perform dastardly manipulations of charts and data such as described in https://peltiertech.com/conditional-formatting-of-excel-charts/ and https://peltiertech.com/vba-conditional-formatting-of-charts-by-value/
We should rename this thread "Replace 'Vary Colors by Point' with 'Vary Colors According to User-Defined Rules'".
Jon Peltier
supported this idea
·
-
8 votesJon Peltier
commented
ArgumentDescription no longer throws an error in recent builds of Excel 2016 for Mac. However, category names are ignored and you must enter a category number, which precludes defining a custom category by name. And in fact, I haven't been able to get my UDFs to appear even in the "All" category.
Jon Peltier
supported this idea
·
The OP is talking about a horizontal bar chart, so the category labels are on the vertical axis, but it's still the X axis.
Excel plots the first category next to the chart's origin, which is the bottom left corner where the axes intersect. The second category is next to that, and so on. Starting at the origin, categories in a column chart go left to right, which seems normal. Starting at the origin, categories in a bar chart go bottom to top, which has always seemed normal to me (knowing about that whole origin thing) but confuses most people.
The way Excel would best address this without messing up existing charts and existing chart code that knows about the chart's origin, would be to default a bar chart to having Categories in Reverse Order checked and Crosses at Maximum selected.