Office 2013 In Depth

Modifying a Chart

After you have the chart embedded on the current worksheet (along with the worksheet data the chart uses) or moved to a new sheet, you can modify the chart’s design, layout, and format. We’ve already talked about the new Charts Tools provided by Excel 2013 (the Chart Elements, Chart Styles, and Chart Filters buttons) that appear to the right of the chart when the chart is selected. When a chart is selected, the Chart Tools become available on the Ribbon.

The Chart Tools have been streamlined in Excel 2013 and are now divided between two Chart Tools tabs: Design and Format (as opposed to three tabs in Excel 2010). The Design tab provides commands that enable you to manipulate the various chart elements (such as the chart title, ...