How to Create a Multiple Range Bar Chart
Table of Contents
What is a Multiple Range Bar Chart
Check the single-series Range Bar charts first. Multiple-series Range Bars come from the following possible combinations:
- Bar Start + Bar + Bar Start + Bar … – standard multi-series Grouped Range Bar chart.
- Bar Start + Bar Start + … + Bar – multi-series Stacked Range Bar chart.
- Bar + Bar … – standard side-by-side multi-series Grouped Bar chart (not a Range chart).
Steps to Create a Multi-Series Range Bar Chart
Start Visual Xtractor or Data Xtractor. Connect to a database. Create or design a SQL query. Run the query and check the results.
- Display and enable the Chart query builder.
- Set a column as Bar Charts – Bar Start chart, for a single-series Waterfall Range Bar.
- Use pairs of Bar Start and Bar, for a multi-series Grouped Range Bar chart.
- Or chain Bar Start charts ending in a Bar, for a multi-series Stacked Range Bar chart.
- Add an optional Label.
- Switch rows with columns for horizontal bars instead.
- Split the multi-series Range Bar chart into smaller single-series Range Bar charts.
Grouped Range Bar Chart
One pair of Bar Start + Bar selection creates a single-series Range Bar chart. Multiple pairs of Bar Start + Bar selections are used for the multi-series Grouped Range Bar charts. Bars from each series are represented side-by-side in groups with bars from the other series.
See the 3D Grouped Range Columns demo query.
Stacked Range Bar Chart
A Bar Start following another Bar Start selection renders the second bar on top of the previous bar. The chain must end with a Bar. The bars never overlap: there could be no invisible portions of a bar, obstructed by another.
The chart below was created by simply removing the “Second” column from the previous query.
Multiple Split Range Bar Charts
Multi-series Range Bar Charts can be split into smaller separate single-series Range Bar Charts. Here is our initial Grouped Range Bar chart after a single toolbar button click.
Customize your Multi-Series Range Bar Chart
- Show thin lollipop sticks with variable marker shapes in the Stacked Range chart.
- Change the X axis label orientation, make them vertical.
- Hide the grid lines and the Y axis labels.
- You may also switch rows with columns, to display horizontal bars instead.
- Or switch to 3D, or hide bars with the legend items…
- Creating multi-series Range Bar Charts in Data Xtractor or Visual Xtractor is fast and intuitive: set pairs of data columns as Bar Start and Bar, for Grouped Range Bar charts.
- Or use a chain of Bar Start selections ending in Bar, for Stacked Range Bar charts.
- Switch rows with columns, to display horizontal bars instead.
- Split multi-series Range Bar charts into smaller separate single-series Range Bars.