Chart Tools: Design The Design Ribbon has options for: Type Data (Select, Edit, Refresh) Chart Layouts Chart Styles.   1. Try it: Format the Data The Chart on Slide 2 is selected. The Chart Tools are available. Go to Chart Tools->Design->Data. Click on Switch Row/Column. What Do You See? The Columns are grouped by Month, now, not Product.   What If It Doesn't Work? This example works when the spreadsheet is open in Microsoft Excel. If Switch Row/Column option is not available, click on Edit Data to open the spreadsheet for this Chart.   Keep going, please... Exam 77-883: Microsoft PowerPoint 2010 4. Creating Charts and Tables 4.2. Insert and modify charts: Switch Rows/Columns Chart Tools ->Design->Data->Switch Row/Column