Switch Row/Column Grayed Out for a Chart in PowerPoint?

Created: Wednesday, June 7, 2017, posted by Geetesh Bajaj at 9:30 am

It’s easy to switch series by clicking the Switch Row/Column button–but wait, do you see the Switch Row/Column button grayed out?


Switch Row/Column Grayed

Once you insert a chart in PowerPoint, you may find that you mixed up the series and categories! It’s easy to switch between both of them by clicking the Switch Row/Column button on the Chart Tools Design tab of the Ribbon–but wait, do you see the Switch Row/Column button grayed out, as shown highlighted in red within the screenshot below?

Switch Row/Column Grayed Out for a Chart in PowerPoint

The solution is simple, although not so apparent. All you need to do is to right-click the chart on your slide to bring up the contextual menu, shown below. Now select the Edit Data option.

Switch Row/Column Edit Chart

Now PowerPoint will bring up an instance of Excel and open your data, ready for editing. Of course, even if you do not want to edit, you will be happy to discover that the Switch Row/Column button is no longer grayed out, as shown in the screenshot below!

Switch Row/Column Active

Related Posts

How Do I Center Content on a PowerPoint Slide? Do you wish there was a way to center align your slide object in PowerPoint? There is no one-click option that you can use, but this is still an easy ...
Open PPTX in PowerPoint 2004 for Mac Here's a question that I was asked recently:Geetesh, I hope it is OK if I ask you a question about PowerPoint. You seem like the expert that can help ...
Ungroup Charts in PowerPoint 2007 Here's a question that I received from someone who once sent me an animated Christmas game! He's probably got a lot of other animated stuff that might...

Filed Under: Troubleshooting
Tagged as: , ,

No Comments

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Plagiarism will be detected by Copyscape

© 2000-2017, Geetesh Bajaj - All rights reserved.

since November 02, 2000