User Manual
How can we help?
Full Site Search

Bar Chart

To visualize and analyze rankings, trends, or proportions of items in your records, you can use bar charts in Ragic reports. For example, you can compare sales data, track quarterly sales trends, or examine the proportion of each department’s expenses relative to the total.

Note: If you don't see any report options on your sheets, it may be related to your report access rights. For issues with viewing or generating reports, please contact your SYSAdmin to check and adjust the access rights configuration.

Generating the Bar Chart

In addition to viewing saved reports created by your SYSAdmin in the Reports tab, you can also generate your own reports.

After generating the Bar Chart, the following page will appear. The settings for the bar chart are explained below:

Bar Chart Types

At the top left, select the type of bar chart. Currently, there are three types available, which can be presented in either "Vertical" or "Horizontal" format:

(1) Clustered Bar Chart: Used for comparing data across multiple categories.

(2) Stacked Bar Chart: Used for comparing parts of a whole.

(3) 100% Stacked Bar Chart: Used for comparing the percentage each data contributes to the total.

Data for Analysis

You can select the # of records or Numeric/Money fields from the sheet.

Select Field Category

Select the "Primary Category" and "Secondary Category" fields, as well as the sorting method for each category.

After selecting the two category fields, the bar chart report will be displayed below. Hover over the bar chart to view the actual values or percentages for each item.

If you wish to analyze only one field, you can select the same field for both category fields.

Setting Item Colors

Choose the item from the "Secondary Category" field, and then you can customize the bar chart colors for it.

Other Display Settings

(1) Hide data with 0 values: Check this option to hide data with zero values.

(2) Show data table: Check this option to display a table below with the actual values or percentages from the sheet.

Other Report Settings

Exporting Reports

You can use the Printer Friendly or Download as PDF option to export reports.

Filtering Reports with Views

When your sheet has Shared Views or the Fixed Filter applied, you can filter the report based on those views.

Embedding Reports

You can embed the report into your website or share a link with others.

Style Settings

You can adjust the report’s style settings, including font, font size, boundaries, etc.

Top of Page Table of Contents

Start Ragic for free

Sign up with Google