Microsoft Excel 2013 Inside Out

Chapter 19. Designing charts

• Selecting data for your chart

• Creating a new chart

• Changing the chart type

• Assigning a series to a secondary axis

• Switching rows and columns

• Choosing a chart layout

• Choosing a chart style

• Moving the chart to a separate chart sheet

• Adding, editing, and removing a chart title

• Adding, editing, and removing a legend

• Adding and positioning data labels

• Adding a data table

• Adding and removing gridlines

• Working with axes

• Modifying a chart’s data

• Adding moving averages and other trendlines

• Adding error bars

WHEN you create a chart in Microsoft Excel, two new tabs appear on the ribbon under the heading Chart Tools. The first of these tabs, Design, offers options related to the structure of the chart—the type of chart, the presence or absence ...