A Horizontal Stacked Bar Chart is a type of bar chart that represents data using horizontal bars. In this chart, multiple data series or categories are stacked horizontally on each other to show the total and the contribution of each part to the whole. Each bar is divided into segments, and each segment represents a different component or category. The length of the bar represents the total, and the segments show the proportion of each component.
The Horizontal Stacked Bar Chart example below is looking at projects by state by priority.
Let's look at the Data and Chart options for this Horizontal Stacked Bar Chart. This chart is looking at the state and priority of projects so we want to use the project table.
Conditions: Setting conditions allows you to query the table you are building the chart off of.
Group by: allows users to organize and aggregate data based on specific fields or criteria. The Group by input is set to State, therefore displaying the different states of projects along the X-axis.
Second group by: allows users to organize and aggregate data based on specific fields or criteria. The Second group by input is set to priority, therefore projects and grouped by state first along the X-axis, then projects are grouped by the priority and represented as the segments of the bars spanning the Y-axis to make up the whole of the projects in that state.
Aggregate Type and Second aggregate type: Refers to a data aggregation method or function used to combine or summarize data from multiple records. They allow users to perform calculations on sets of records to derive meaningful insights. Some common aggregate types include:
Count: Calculates the number of records in a set.
Count Distinct: counts the number of unique, non-duplicated values in a field.
Sum: Adds up the values of a specified field for a set of records.
Average: Computes the average value of a specified field for a set of records.
Minimum: Finds the minimum value of a specified field in a set of records.
Sort by and Second sort by: Allows user to determine the order of the list. Sort by can set as Value Descending, Value Ascending, Alphabetically Descending, Alphabetically Ascending.
Now let's look at the Style Options that have been changed from the default Style Options to give the Horizontal Stacked Bar Chart more clarity. First a custom title of "Projects by State by Priority" is set to provide quick insight into what the information the chart is displaying.
Next, the Display legend and Data values toggles are engaged to display the legend at the bottom of the chart.
Next, click the Data labels dropdown and engage the Labels, Total Data Value, and Individual Values toggles.
Engage the Display grid toggle to give the Horizontal Stacked Bar Chart a grid.
