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.
Understanding a Data Series
Every column or row of numbers included in a chart is called a "data series." Some charts include more than one series. For example, a pie chart shows the percentages of a single data series. A bar chart can show how several data series relate to one another.
Creating a Chart
Two ways to insert a chart are by selecting "Charts" in the Quick Analysis dialog box or by navigating to the Insert tab and choosing the chart type from the Charts group. The second method is preferable when you need a specific chart type. To make changes to a chart, first click anywhere in the chart area to make it active; this displays a "Chart Tools" area on the right side of the menu bar.
Changing the Order and Placement of Data Series
To change the order of the data in either the Category axis -- the x-axis -- or the Value axis -- the y-axis -- double-click on the axis to open the Format Axis dialog box. Click the "Axis Options" button and then the check box for "Values in Reverse Order." Right-clicking on any chart element shows an option to format it in the shortcut menu.
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.
- Photo Credit Daniilantiq/iStock/Getty Images
How to Make Numbers Ascending in Excel
Arranging data points in consecutive order in Microsoft Excel makes values easier to locate. Although you can define very complex sorting criteria,...
How to Format for Ascending Date in Excel
Microsoft Excel is a spreadsheet program that lists information in rows and columns. Excel can be used to create reports with charts...
How to Use Excel to Organize Lists
Microsoft Excel not only helps you analyze data but also keeps you organized. You can customize Excel for projects so they're easier...
How to Change the Descending Order in a Folder
The Windows operating system allows users to arrange files however best suits their needs. This includes the ability to sort files in...
How to Reverse the Order of a Chart in Excel 2003
Microsoft Excel helps you to organize and manage vast amounts of data. Excel's charts and graphs function can help you make sense...
How to Sort Ascending Numerically in Excel
A busy Microsoft Excel spreadsheet can present a lot of competing information for your eyes and brain to digest. To make things...
How Do I Create a Pareto Chart in Microsoft Excel?
According to QAProject.org, a Pareto chart displays the relative importance of events according to categories. A Pareto chart provides a tool to...