Customizing Your Chart
The Quick Analysis tool is great for getting a quick chart on your sheet. Maybe you want to tweak some things. Let’s look at some of the customization options you have in Excel 2013.
To change the chart title, double-click the Chart Title placeholder text.
Modify Elements Are Displayed
You can easily change which chart elements are displayed by clicking on the chart and then clicking on the ~ez_ldquo+ez_rdquo~ icon. From here, you can select or de-select items such as axes, titles, trend lines, data points and a data table.
Change the Appearance
In order to change the color scheme, click on your chart and then click the Paintbrush icon. From here, you can choose a different style and color scheme (Figure 5).
Filter What Is Displayed
You can filter what is displayed using the filter icon. Click your chart and then click the filter button. Simply select or de-select which items you wish to display on the chart.
Change Chart Type
If you don’t like the overall layout of your chart, you can click on the chart and then click on Chart Tools -> Design -> Change Chart Type. From here, you have the option of changing the overall look of your chart. In Figure 6, you can see I have selected All Charts and then the Line -> 3D Chart type.