# Vertical Bar Charts in the Report Builder

Vertical bar charts display data in a series of bars that run from the bottom to the top of the chart. Vertical bar graphs use the x-axis for labeling categories, while numeric data is measured along the y-axis. This type of chart is useful if one axis does not have numeric data.

Drop Y-Axis

In a vertical bar chart, the y-axis includes numeric information, such as the number of client computers or jobs in each status.

Drop X-Axis

In a vertical bar chart, the x-axis includes text-based categories, such as client computer names or job statuses.

## General Properties

In the Report Builder, on the Properties tab, on the General tab, you can configure settings for a vertical bar chart.

Chart Title

Allows you to specify the name of the chart.

ID

By default, displays the automatically-generated identifier for the chart. You can specify a different chart ID.

Data Set

Displays the data set used to create the chart. This box is not editable.

Y-Axis Title

Allows you to specify the label for y-axis data that runs vertically up the side of the chart.

X-Axis Title

Allows you to specify the label for x-axis data that runs horizontally across the bottom of the chart.

Chart Type

By default, displays the type of chart you chose to create. You can change the chart type by selecting another type from the list.

Grouped

When selected, displays multiple Y-Axis bars side-by-side instead of stacked. This option appears only if you added multiple Y-Axis values.

Show as 3D

When selected, displays the bars as three-dimensional, and at the same time, on the General tab, displays the 3D Options section.

When cleared, displays the bars as two-dimensional, and also hides the 3D Options section.

3D Options

This section appears when you select Show as 3D and contains settings for 3D bars in a chart.

- 3D Stacking

  This option displays the bars in a stacking format.

- 3D Vertical Angle

  In this box, you can configure the bars to display at a specific vertical angle, such as 25 degrees.

- 3D Horizontal Angle

  In this box, you can configure the bars to display at a specific horizontal angle, such as 15 degrees.

- 3D Depth

- 3D Column Padding

  In this box, you can specify the amount of padding that displays around the bar, such as 30 pixels.

Show Gridlines

When selected, shows the gridlines in the chart. When cleared, hides the gridlines in the chart.

Toggle Chart

When selected, this option converts the x-axis data into descending order. When cleared, this option converts the x-axis data to ascending order.

Show Data Labels

When selected, displays the value associated with each bar. When cleared, hides the value associated with each bar.

Show Legend

When selected, this option displays a legend in the chart, and at the same time, on the General tab, displays the Max Legend Label Length and Legend Position options.

When cleared, this option hides the legend from the chart and also hides the additional legend options on the General tab.

- Legend Position

  In this list, you can configure the placement of the legend in the chart. The legend can appear at the Top, Bottom, Right or Left of the bars.

- Max Legend Label Length

  In this box, you can configure the maximum number of characters tha

  t are allowed to appear in the legend labels.

Show in Tabular Form

When selected, this option converts the chart to a table. When cleared, this option converts the table to a chart.

Disable Interactivity

To disable all interactive elements in the component, move this toggle key to the right.

Hide Header

To hide header information in the component output, select this option.

- Visible: Select who can view the component.

  - All: To allow everyone see the component, select this option.

  - CommCell Admin: To allow only CommCell administrators see the component, select this option.

  - Tenant Admin: To allow only only tenant administrators see the component, select this option.

  - Custom: To allow users see the component based on the permissions, select this option, then in the Visible Expression box, enter a JavaScript statement.

  For example, to allow MSP users view the component, in the Visible Expression box, enter := return cv.isMspUser.

## Field Properties

In the Report Builder, on the Properties tab, on the Fields tab, you can configure settings for a vertical bar chart.

### Sorting

Sort By

Allows you to sort the data by the X-Axis or Y-Axis values.

Sort Order

Allows you to sort data in ascending or descending order.

### Measure

To configure settings in Formatter under Measure or Dimension, see Formatting Data in Components for Build Your Own Reports.

Auto convert values

When selected, automatically converts display sizes for labels. For example, 10,000 KB is converted to 10 MB.

Count (Y-Axis Label)

- Aggregate

  Allows you to specify the type of numeric value to display in the bars.

- Formatter

### Dimension

Slant X-Axis Labels

When selected, displays x-axis labels at a slanted angle and allows you to specify the degree of the angle.

When cleared, displays x-axis labels horizontally.

If there are over five labels, then labels will automatically display as slanted.

- Angle

  Allows you to specify the degree of the angle.

X-Axis Label

When selected, you can configure the data points that appear in the chart.

- Max Points

  Allows you to specify the maximum number of data points that will appear in the chart.

- All Points

  When selected, displays all data points. When cleared, the Max Points setting controls the number of data points that appear in the chart.

- Formatter

### Custom Colors

To configure a color for each x-axis data point, click Customize Series Colors , select an x-axis data point from the list, and then select a color from the Color dialog box.

To delete the custom color, click the trash icon next to the x-axis data point.

Any bar that is not configured with a custom color displays the color that is configured in the Default Color box.

### Custom Groups

To configure settings under Custom Group, see Configuring Custom Groups in Charts.

Field Name Option

When selected, enables the custom group settings you configured.

Field Name Dialog Box

Allows you to specify a set of custom bars based on a formula that you enter. Select a field name, and then click Edit to open this dialog box.

## Custom Code Properties

In the Report Builder, on the Properties tab, on the Custom Code tab, you can configure settings for a vertical bar chart.

On Click

Allows you to configure an action on a bar or the entire chart using JavaScript.

- Run a workflow: From the list, select a workflow that runs.

- Open Report: From the list, select a report that opens.

- Url: In the box, you can enter a URL that opens a web page.

- Custom: In the Expression box, enter a JavaScript expression.

- Add Table Record:

- Edit Table Records:

To configure settings under Custom Code, see Configuring Custom Code and Custom Styles for Reports.

×

Loading...