Adding formatting to your analysis

This tutorial shows you how to apply formatting to the results of your analysis and customize the general appearance of the results. After you create an analysis, default formatting rules are applied to the results.

What you'll learn

In this tutorial, we'll show you how to:

  • Apply formatting to a column header and change the name of the header
  • Apply formatting to alternate rows in the analysis

What you'll need

Step 1: Applying formatting to a column header

First, we'll apply some formatting to a column header in our analysis.

To apply formatting to your analysis:

  1. Open the analysis you were working with in Adding totals to your analysis.
  2. Click the Results tab.
  3. Click Edit View The Edit icon in the Table view.

    An image highlighting the Edit View icon in the table view

    The Layout pane appears.

  4. In the Layout pane, click An image of the Options icon Options for Campaign Product and select Format Headings.

    An image showing the Options menu with Format Headings selected

    The Edit Format dialog appears.

  5. Enter Product in the Caption field.
  6. Click the Color list in the Font area. Select a red color from the Color Selector dialog, and click OK.
  7. Click the Background Color list in the Cell area. Select a light blue color from the Color Selector dialog, and click OK.

    The completed dialog should look like this:

    An image of the Edit Format dialog

  8. Click OK.

    Your changes appear in the Preview pane.

    An image of the preview pane that shows formatting changes to a column header

  9. Click Done and then save your analysis.

Step 2: Applying styles to alternate rows

Now, we'll apply styles to alternate rows in the analysis.

To apply styles to alternate rows:

  1. On the Results tab, Click Properties An image of the Edit Properties icon on the Table view toolbar.

    An image highlighting the Properties icon in the table view

    The Table Properties dialog appears.

  2. Select the Enable alternate styling check box and the Repeat cell values check box.

    An image of the Table Properties dialog in which Enable alternate styling is selected

  3. To change the formatting of the alternate rows, click Styles An image of the Styles icon.

    The Alternate Row Format dialog appears.

  4. Click the Background Color list in the Cell area. Select a light blue color from the Color Selector dialog, and click OK.

    An image of the Alternate Row Format dialog

  5. Click Done and save your analysis.

    An image of the analysis after formatting

Now that you're done

Now that you added formatting to your analysis, check out the next tutorial Adding a graph to your analysis.