Start bar and line charts in Executive Reports at zero

Create executive reports in Search Ads 360

When using a bar, line, or mixed bar and line chart to visualize your data in a Search Ads 360 executive report, you can customize the axes to change the scale and appearance of the data.

You can choose whether to start the measurement of the data points at zero or at a higher number. For example, for a bar chart that compares the total number of clicks and visits over the past 30 days, the totals on the y-axis range from 200 to 400.

Bar chart that compares clicks and visits for past 30 days

 

You can change the range of measurement to start one or both metrics at zero (shown in the following bar chart) to more accurately represent the scale of change between data points in a bar chart.

Bar charts that compares clicks and visits with axis starting at zero

Because line charts are generally used to show trends, you may want to start the axis at a higher number. 

 

If the data uses the same unit of measurement, you can also display the metrics on one axis to compare them along the same scale. As shown in the preceding images, the chosen metrics are counts, so they can be displayed using one axis. Clicks and costs cannot be displayed on one axis because clicks are counted and costs are shown in a currency.

For bar charts only, you can switch the orientation of the bars from vertical (the default) to horizontal. Learn more about displaying horizontal bars.

Start a bar, line, or mixed bar and line chart axis at zero

  1. Create an executive report or open an existing executive report:

    1. From the top navigation bar in Search Ads 360, click Executive Reports.

    2. Click on a report title.

  2. Create or edit a bar, line, or mixed bar and line chart.

  3. If a chart contains more than one metric, you can choose to start one or both metrics at zero. Click one or both of the following check boxes:
    • Start left axis at 0 
    • Start right axis at 0 (available only if the chart contains two metrics)

    Edit executive report change axes options. Three check box options shown. The Display metrics on one axis, check box is blurred. The Start left axis at 0 and Start right axis at 0 check boxes are highlighted with a rectangle around them

    For horizontal bar charts, click one or both of the following check boxes:

    • Start bottom axis at 0
    • Start top axis at 0 (available only if the chart contains two metrics)
  4. Save your changes.
Note: To start a left or right axis at a higher number, remove the check mark from the axis check box.

 

To combine metrics on a single axis

  1. Create an executive report or open an existing executive report:

    1. From the top navigation bar in Search Ads 360, click Executive Reports.

    2. Click on a report title.

  2. Create or edit a bar, line, or mixed bar and line chart.
  3. If the metrics use the same unit of measurement, select the Display metrics on one axis check box.Executive reports edit chart with three axis options shown. Display metrics one one axis option is highlighted in red rectangle. The other two check boxes, Start left axis... and Start right axis ...  are blurred

    The range for the metrics are displayed on the left axis.

  4. Optionally, select the Start left axis at 0 checkbox to start the axis range at zero.

    For horizontal bar charts, select the Start bottom axis at 0 check box.

  5. Save your changes.
Was this article helpful?
How can we improve it?