Share via

Change orientation of bars in bar charts??

Anonymous
2012-09-21T19:01:00+00:00

In Excel, under the Chart menu "Source Data" in the window "Select Data Source" the tab "Switch Row/Column" is grayed out. PLEASE how can I activate this tab? 

More importantly, how do I change the orientation of bars in a bar chart form horizontal to vertical????

I have MS Office for Mac 2011 software.

Reply to ******@gmail.com ASAP please. Thank you.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2012-09-21T19:47:18+00:00

    It sounds to me like the answer to both of your questions may be that you need to create a Column Chart rather than a Bar Chart... Bars plot horizontally, Columns plot vertically.

    As for the Switch Row/Column button [also in the Switch Plot control in the Data group of the Charts tab of the Ribbon], the only time I've seen it dimmed is if insufficient/inaccurate data is in the dialog.

    In order to offer anything more definite we need to have a much fuller description of the data, how it's arranged, as well as a more complete understanding of what you're attempting to plot.

    40+ people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest