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:
|
|
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.