Cart

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:

  1. Bar Start + Bar + Bar Start + Bar … – standard multi-series Grouped Range Bar chart.
  2. Bar Start + Bar Start + … + Bar – multi-series Stacked Range Bar chart.
  3. 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.

  1. Display and enable the Chart query builder.
  2. Set a column as Bar Charts – Bar Start chart, for a single-series Waterfall Range Bar.
  3. Use pairs of Bar Start and Bar, for a multi-series Grouped Range Bar chart.
  4. Or chain Bar Start charts ending in a Bar, for a multi-series Stacked Range Bar chart.
  5. Add an optional Label.
  6. Switch rows with columns for horizontal bars instead.
  7. 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.

Grouped Range Column Charts

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.

Stacked Range Column Chart

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.

Multiple Split Range Bar Charts

Customize your Multi-Series Range Bar Chart

  1. Show thin lollipop sticks with variable marker shapes in the Stacked Range chart.
  2. Change the X axis label orientation, make them vertical.
  3. Hide the grid lines and the Y axis labels.
  4. You may also switch rows with columns, to display horizontal bars instead.
  5. Or switch to 3D, or hide bars with the legend items…

Custom Stacked Range Column Chart

Conclusion

  • 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.