(2 votes, average: 5.00 out of 5)
Loading...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?
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.
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!
Related Posts
![Data Labels Show [CELLRANGE] Rather Than the Expected Value or Number in PowerPoint Charts](https://notes.indezine.com/wp-content/uploads/2018/08/Slide-with-data-labels-in-PowerPoint-2010-for-Windows-150x150.png)
Do you see charts with data labels that read [CELLRANGE] rather than a real value or number? Do you see this behavior more in PowerPoint slides you re...
A few days ago, I needed to demo some animation effects in a training class. I happened to open one of my older presentation decks, and this one was p...
Let us assume you received or created a presentation in a version earlier than PowerPoint 2003 for Windows (97, 2000, 2002). You probably have fonts e...
The ProblemMany users believe that their Microsoft Windows operating system includes PowerPoint, or other Microsoft Office programs. Their reasoning i...