You can change the format of individual chart elements, such as the chart area, plot area, data series, axes, titles, data labels, or legend. Show
Two sets of tools are available for formatting chart elements: the Format task pane and the Chart Tools Ribbon. For the most control, use the options in the Format task pane. Format your chart using the Format task paneSelect the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart element.
Clicking the small icons at the top of the pane moves you to other parts of the pane with more options. If you click on a different chart element, you’ll see that the task pane automatically updates to the new chart element. For example, to format an axis:
Format your chart using the Ribbon
You can use the Format <Chart Element> dialog box to make formatting changes, or you can apply predefined or custom shape styles. You can also format the text in a chart element. What do you want to do?
Change the format of a selected chart element
Top of Page Change the shape style of a selected chart elementIn a chart, click the chart element that you want to change, or do the following to select the chart element from a list of chart elements:
To apply a predefined shape style, on the Format tab, in the Shape Styles group, click the style that you want.
Tip: To see all available shape styles, click the More button To apply a different shape fill, click Shape Fill, and then do one of the following:
To apply a different shape outline, click Shape Outline, and then do one of the following:
To apply a different shape effect, click Shape Effects, click an available effect, and then select the type of effect that you want to use. Note: Available shape effects depend on the chart element that you selected. Preset, reflection, and bevel effects are not available for all chart elements. Top of Page Change the format of text in a selected chart elementTo format the text in chart elements, you can use regular text formatting options, or you can apply a WordArt format. Use text formatting to format text in chart elements
Top of Page Use WordArt styles to format text in chart elements
Top of Page Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. Which is a group of formatting elements you apply to a document?A style is a set of formatting that is applied automatically to the document as you create and modify it.
What are the elements of formatting?Formatting elements were designed to display special types of text:. <b> - Bold text.. <strong> - Important text.. <i> - Italic text.. <em> - Emphasized text.. <mark> - Marked text.. <small> - Smaller text.. <del> - Deleted text.. <ins> - Inserted text.. Which command would you use to copy and paste formatting from one object to another?You can use also use keyboard shortcuts to copy and paste formatting between shapes:. Select the shape you want to copy formatting from, then press Ctrl+Shift+C.. Select the shape you want to copy formatting to, then press Ctrl+Shift+V.. What would you use to force text on to a new page that will have its own setting separate from the rest of the document?Page breaks are also used to start a chapter on a new page, a common standard in publishing. To ensure that the new chapter does appear on a separate page, insert a page break immediately following the text at the end of the chapter.
|