Hi PJ,
To sort/re-order a stacked bar chart in Excel 2007, you can follow these steps:
- Click on the chart to select it.
- Click on the "Chart Tools" tab in the ribbon.
- Click on the "Design" tab.
- Click on the "Select Data" button in the "Data" group.
- In the "Select Data Source" dialog box, click on the "Switch Row/Column" button to switch the data orientation if necessary.
- Click on the "Edit" button in the "Legend Entries (Series)" section.
- In the "Edit Series" dialog box, you can change the order of the series by selecting a series and clicking on the "Move Up" or "Move Down" button.
- Click on the "OK" button to close the "Edit Series" dialog box.
- Click on the "OK" button to close the "Select Data Source" dialog box.
By following these steps, you should be able to
sort/re-order the values in your
stacked bar chart according to your preference.