Feedback by UserVoice

Jon Peltier

My feedback

  1. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  2. 38 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier shared this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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]

    Jon Peltier commented  · 

    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.

  4. 32 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  5. 38 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  6. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  7. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  8. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  9. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  10. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  11. 49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  12. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  13. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  14. 98 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  15. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

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

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  17. 15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  18. 745 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    186 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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.

  19. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  20. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Jon 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  · 
← Previous 1 3

Feedback and Knowledge Base