Nội dung

Add Chart Titles You can make your chart easier to read and easier to understand by adding one or more titles to the chart. For example, you can add a chart title, which is a title that appears at the top of the chart and is usually a word or short phrase that describes the chart data. You can also add titles to the chart axes. The primary horizontal axis title is a title that appears below the chart’s category (X) axis; the primary vertical axis title is a title that appears the left of the chart’s value (Y) axis. Add Chart Titles 1 Click the chart. 2 Click the Layout tab. 3 Click Chart Title ( ). 4 Click Above Chart. • 5 Excel adds the title. 2 3 4 5 Type the title. 1 6 Click Axis Titles ( ). 7 Click Primary Horizontal Axis Title. 8 Click Title Below Axis. • 9 Excel adds the title. Type the title. ! 6 7 0 8 0 Click . ! Click Primary Vertical Axis Title. @ Click Rotated Title (not shown). • # Excel adds the title. Type the title. # 9 190 13_577639-ch11.indd 190 3/15/10 2:47 PM 11 CHAPTER Add Data Labels You can make your chart easier to read by adding data labels. A data label is a small text box that appears in or near a data marker and displays the value of that data point. Excel offers several position options for the data labels, and these options depend on the chart type. For example, with a column chart you can place the data labels within or above each column, and for a line chart you can place the labels to the left or right, or above or below, the data marker. Add Data Labels 2 3 1 Click the chart. 2 Click the Layout tab. 3 Click Data Labels ( ). 4 Click the position you want to use for the data labels. Note: Remember that the position options you see depend on the chart type. 4 1 • Excel adds the labels to the chart. 191 13_577639-ch11.indd 191 3/15/10 2:47 PM Position the Chart Legend You can change the position of the chart legend, which is a box that appears alongside the chart and serves to identify the colors associated with each data series in the chart. By default, the legend appears to the right of the chart’s plot area, but you might prefer a different location. For example, you might find the legend easier to read if it appears to the left of the chart. Alternatively, if you want more horizontal room to display your chart, you can move the legend above or below the chart. Position the Chart Legend 1 Click the chart. 2 Click the Layout tab. 3 Click Legend ( ). 4 Click the position you want to 3 use for the legend. 1 • 2 4 Excel moves the legend. 192 13_577639-ch11.indd 192 3/15/10 2:47 PM 11 CHAPTER Display Chart Gridlines You can make your chart easier to read and easier to analyze by adding gridlines. Horizontal gridlines extend from the vertical (value) axis and are useful with area, bubble, and column charts. Vertical gridlines extend from the horizontal (category) axis and are useful with bar and line charts. Major gridlines are gridlines associated with the major units: the values you see displayed on the vertical and horizontal axes; minor gridlines are gridlines associated with the minor units: values between each major unit. Display Chart Gridlines 2 3 4 5 1 Click the chart. 2 Click the Layout tab. 3 Click Gridlines ( ). 4 Click Primary Horizontal Gridlines. 1 5 Click the horizontal gridline option you prefer. • Excel displays the horizontal gridlines. 6 Click . 7 Click Primary Vertical 6 Gridlines. 7 8 Click the vertical gridline 8 option you prefer. • Excel displays the vertical gridlines. 193 13_577639-ch11.indd 193 3/15/10 2:47 PM Display a Data Table You can make it easier for yourself and others to interpret your chart by adding a data table. A data table is a tabular grid where each row is a data series from the chart, each column is a chart category, and each cell is a chart data point. Excel gives you the option of displaying the data table with or without legend keys, which are markers that identify each series. Display a Data Table 1 Click the chart. 2 Click the Layout tab. 3 Click Data Table ( ). 4 Click Show Data Table with Legend Keys. • • 2 3 4 If you prefer not to display the 1 legend keys, click Show Data Table. Excel adds the data table below the chart. 194 13_577639-ch11.indd 194 3/15/10 2:47 PM 11 CHAPTER Change the Chart Layout and Style You can quickly format your chart by applying a different chart layout and a different chart style. The chart layout includes elements such as the titles, data labels, legend, gridlines, and data table. Excel’s Quick Layouts feature enables you to apply these elements in different combinations with just a few mouse clicks. The chart style represents the colors used by the chart data markers and background. Change the Chart Layout and Style 2 3 5 4 1 Click the chart. 2 Click the Design tab. 3 Click Quick Layout ( ). 4 Click the layout you want to use. 1 Excel applies the layout. 5 Click the Chart Styles . 6 Click the chart style you want to use. 6 • Excel applies the style to the chart. 195 13_577639-ch11.indd 195 3/15/10 2:47 PM Select a Different Chart Type If you feel that the current chart type is not showing your data in the best way, you can change the chart type with just a few mouse clicks. For example, you might want to change a bar chart to a pie chart or a line chart to a stock chart. As you will see in the Tips on the following page, you can also save yourself some work by configuring Excel with a new default chart type, and by saving the current chart type and chart formatting as a template that you can reuse later on. Select a Different Chart Type 1 Click the chart. 2 Click the Design tab. 3 Click Change Chart Type ( ). 2 3 1 The Change Chart Type dialog box appears. 4 4 Click the chart type you want to use. 196 13_577639-ch11.indd 196 3/15/10 2:47 PM 11 CHAPTER Visualizing Data with Excel Charts Excel displays the chart type configurations. 5 5 Click the configuration you want to use. 6 Click OK. 6 • Can I tell Excel to always use a particular chart type each time I create a new chart? Yes, you can configure that chart type as the default type for new charts. Follow Steps 1 to 5 to open the Change Chart Type dialog box and select a chart type and configuration. Click the Set as Default Chart button, and then click OK. Excel applies the new chart type. Can I save the chart type and formatting so that I can reuse it later on a different chart? Yes. You do this by saving your work as a chart template. Follow the steps in this section and in the previous few sections of this chapter to set the chart type, titles, labels, legend position, gridlines, layout, and style. Click the Design tab, click Save as Template ( ), type a name for the template, and then click Save. To reuse the template, follow Steps 1 to 3, click Templates, click your template, and then click OK. 197 13_577639-ch11.indd 197 3/15/10 2:47 PM Chapter 12 Formatting Excel Charts You use Excel charts to visualize worksheet data, and you can make these visualizations more eye-catching and more effective by formatting chart elements. In this chapter, you first learn the general technique for formatting any chart elements. In the rest of the chapter, you learn specific chart customization techniques, including formatting the chart background, customizing a chart element’s outline, applying special effects to a chart element, and applying a style to a chart element. 14_577639-ch12.indd 198 3/15/10 2:48 PM Format Chart Elements . . . . . . . . . . . . . . . . . . . . . . . . 200 Customize a Chart Element Background . . . . . . . . . . . . . 202 Set a Chart Element’s Outline . . . . . . . . . . . . . . . . . . . . 204 Add Effects to a Chart Element . . . . . . . . . . . . . . . . . . . 206 Apply a Style to a Chart Element. . . . . . . . . . . . . . . . . . 208 14_577639-ch12.indd 199 3/15/10 2:48 PM