Formatting Page Headings and Page Footings

How to:

Page headings and page footings supply context and key information about a chart, such as its purpose, audience, and author. Page headings and page footings also enhance visual appeal.

Procedure: How to Add a Page Heading and Page Footing to a Chart

The procedure uses sample values, but you can supply values that apply to your own charts.

This feature is available in Query Design view, Live Preview, and Document mode.

  1. Create a chart.
  2. On the Home tab, in the Report group, click Header & Footer.

    The Header & Footer dialog box opens.

    Tip: Another way to access the Heading & Footing dialog box is to click the arrow next to the Header & Footer button. Doing so opens a drop-down menu from which you can select the heading or footing that you want to work with. After you make your selection, the Header & Footer dialog box opens, and the heading or footing that you selected is active.

  3. Click the tab for the page heading or page footing, depending on which you want to add.

    By default, the Page Heading tab is selected. In this procedure, accept the default to add a page heading first.

  4. Click inside the design area of the dialog box, and type the text for the page heading.

    For example, the text for a sample page heading might be Customers By Occupation.

  5. Using the styling options, apply styling to the page heading text.

    For example, 14 pt. bold Helvetica with center alignment.

  6. Click Apply to save the changes that you have made, without closing the dialog box.
  7. To add a page footing, click the Page Footer tab.

    For this procedure, you are going to add one of the supplied quick text options, followed by some text of your own.

  8. Click the down arrow next to the preformatted text button, and click Created by from the drop-down list.
  9. Complete the text by typing the applicable value within the supplied text, for example, Sales Manager.
  10. Change the styling as you want.
  11. Click OK to save the page heading and page footing and close the Header & Footer dialog box.

    The chart contains the page heading and page footing that you added and styled.

    The following image shows a chart with a styled header and footer.

    Page Heading and Footing Example
  12. To make changes to either the page heading or page footing, return to Design view. Right-click the header or footer, and click Edit from the drop-down menu.

Procedure: How to Control the Rendering of a Page Heading and Page Footing

You can control the way in which a page heading and page footing are rendered on a chart at run time.

  1. Create a chart.
  2. Open the Header & Footer dialog box, as described in How to How to Add a Page Heading and Page Footing to a Chart.
  3. Click the Text options for chart button Text option for chart button.

    A drop-down menu, with two options for rendering the page heading and page footing, opens.

    Tip: Your selection for a page heading also applies to a page footing, and vice versa.

    • Create Header and Footer as text renders the heading and footing as text elements that are separate from the chart image.
    • Embed Header and Footer in the chart renders the heading and footing text as part of the chart image. This is the default value.
  4. Click OK to save your selection and close the Heading & Footing dialog box.