Group Column
Last updated
Last updated
Check out the below given walk-through on how to use the Group Column chart component in Designer module.
A group column chart (clustered column chart, stacked column chart) extends the column chart, plotting numeric values for levels of two categorical variables instead of one. Columns are grouped by position for levels of one categorical variable, with color indicating the secondary category level within each group.
To compare various relative values based on a common parameter
If you want to compare your region-wise sales for 2012. A Column chart can easily facilitate that comparison. The Stacked/group chart is beneficial as it can facilitate both comparisons as well as part-to-whole relationship.
The user can enable the Auto axis, the Base Zero value, Horizontal & Vertical marker line, zero marker line and can change the color of lines, increase and decrease the color Transparency by opacity.
The user can change the background color of the chart, can get the border for the chart and can change the border color, can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow.
The user can enable the “Enable Context Menu”, then it is possible to download the reports in different formats if we click on the chart from the preview section. The heading and sub heading of that downloaded chart and the name of the downloaded file can be change from this section.
The user can change Y-axis values in units to %, T, Lacs, M, etc. Precision if we want the value in decimal format. Currency if we want the value in INR, Pound, USD. Position of the currency if it's in prefix and currency in Rupee then the sign will be seen in left-side if it's in suffix then it will be seen in right-side. Number Formatter if we want it in Indian or international.
The user can change the height, width, top, left, chart type, column type & Line form. In this case, we have changed the chart type to stacked & base type to plain.
The user can enable the internal legend if we want to show and can change the font size, color, style, etc.
This Properties will work when we have a category field and that category value should display in different chart. For Example: If we have a Year for each year, it will generate a different chart.
The user can enable the subtitle to display the second title. The user can change the Name, Font color, size, style for the subtitle.
The user can change Title Name, Font color, size, style, etc.
The user can show the description of the series can use the tooltip by enabling it.
The user can change the axis name, Font color, Font size, Enable the axis line, and the axis color.
The user can change the axis name, Font color, Font size, Enable the axis line, and the axis color.
The user can change the color of each bar by selecting any of the series. There is an option to change the column type as well. Select either Line or Column options.
The following data was used to generate the given example:
| Category | Items | SaleDay1 | SaleDay2 | SaleDay3 |
|---|---|---|---|---|
Furniture | Tables | 140 | 30 | -20 |
Furniture | Furnishing | 40 | 30 | 70 |
Furniture | BookCase | 24 | 40 | 80 |
Furniture | Chairs | 20 | 80 | -50 |
Office Suppliers | Scissors Rulers | 65 | 65 | 77 |
Office Suppliers | Chairs | 45 | 87 | -34 |
Technology | Machines | 40 | 30 | 70 |
Technology | Telephones | 54 | 30 | 60 |
Use the Category column as Category field, Items as Sub-category field, and other columns as Series fields to plot the data in the below-given chart.
