How to create a variable width column chart
2.1. Prepare stacked data values
A variable width column chart requires measure values that are stacked along the bottom axis. A range chart by itself will not accomplish this so if you have un-stacked values, you will need to use the Cumulative Total formula function to help you calculate measures that will plot a running total of the bottom axis values.
The required stacked values should look like the values in the following sample Excel spreadsheet.
Once you have prepared the data, create a data connector in Dundas BI to connect to that data. For example, drag the Excel file to Explore.
2.2. Add a range chart
Create a new dashboard based on the Blank dashboard template.
Go to the toolbar, click Data Visualization, and select Range Chart.
2.3. Set up visualization bindings
Open the Data Binding Panel for the range chart. Click Bindings.
Drag-and-drop data columns from Explore onto the chart bindings as shown in the table below.
|SERIES 1 HORIZONTAL POSITION||StartX|
|SERIES 1 HORIZONTAL RANGE END||EndX|
|SERIES 1 RANGE START||StartY|
|SERIES 1 RANGE END||EndY|
|SERIES 1 SERIES GROUPING||Name|
The goal here is to set up a single range chart series where four measures are used to position each of the four sides of each bar/column.
If the axes were previously plotting non-numeric values, ensure both the left axis and bottom axis have their Scale Type property set to Numeric.
The easiest way to give each data point its own color from the palette is to make each one its own series using a series hierarchy: add a hierarchy to Columns (Series) on the metric set or move one there from Rows (Data Points).