Excel charts are an effective way to convey data visually, but many people find it tricky to update the individual chart elements, especially the sorting and placement of data series and categories. In addition to the previous right-click formatting options, Excel 2013 has a new Formatting Task Pane, which allows quick selection of individual chart elements. Sometimes you need to showcase different data on the x-axis than Category. Perhaps you wish to plot the Legend information on the Category axis or vice versa. To swap the chart’s Legend entries and Category axis, go to the Design menu under Chart Tools and click the “Switch Row/Column” button in the Data grouping. Excel 2013 includes on-object buttons that appear to the right of any chart when it is active. These buttons provide quick access to common chart customization features.
