Chart wizard—appearance

The Appearance dialog box allows you to customize the appearance of the report chart. The fields and controls available in this dialog box are described in the following table:

Section Field Description

General

Chart Type

Select a theme for the chart report from the list options.

 

For missing columns

Select either of the following options:

  • Hide column: Hide the column that is empty from the generated table report.
  • Show error: Show error if a column is missing from the generated table report.

 

Chart Orientation

Select the chart orientation, either vertical or horizontal.

 

Display Series Labels

Enable to display the series labels.

 

Top padding

Select for Line chart types. This option provides top padding that avoids large lines to go out of the chart.

 

3-D Chart

Select to enable a 3- Dimensional effect to the chart

 

Display legend

Select to show the legend, and then select the position of legend: None, Left, Right, Top, or Bottom.

 

Disable sampling

Applicable for CSV files. Select the check box to disable sampling to reduce the size.

Charts that use CSV fils, sampling is enabled by default. Disabling sampling will use the entire set of data for rendering the charts.

 

Composition

Select either of the three: Side-by-side, Stacked or Stacked 100%.

 

Use Percentage slices

This option appears only for Pie, Donut, and Half-donut chart types.

Select to indicate the percentage each slice represents instead of the actual value

X Axis

Title

The title of the X axis that will appear in the chart report.

 

Grid lines

Grid lines will appear in the background of the chart to show the cell division.

 

Hide labels

Select to hide cell labels.

 

Angle Labels

Select the angle label you want to show in the report chart.

 

Treat values as strings

Select to make the X-axis values appear as strings.

 

Remove trailing zeros

Select to remove the trailing zeros in the X-axis values.

 

Wrap labels

Select to wrap cell labels.

Y Axis

Title

The title of the Y axis that will appear in the chart report.

 

Grid Lines

Grid lines will appear in the background of the chart to show the cell division.

 

Logarithmic

Use a logarithmic scale for the axis.

Secondary Y Axis

Title

The title of the Y axis that will appear in the chart report.

 

Grid Lines

Grid lines will appear in the background of the chart to show the cell division.

 

Logarithmic

Use a logarithmic scale for the axis.

Preview

 

View a preview of the chart or data.

The image below is an example showing the XY Chart, with vertical Chart orientation, displaying series labels, Side-by-side composition. X Axis with a Title, Grid lines and Angle labels enabled.Y Axis with Grid lines enabled.