Hitachi Vantara Pentaho Community Wiki
Child pages
  • Bar-Line Combination Chart

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{scrollbar}

Bar\Line Combination Chart

Anchor
barlinechart
barlinechart

The bar\line combination chart plots a set of values as bars for each specified series in the given dataset. This chart will also plot specified series as lines, using the right axis as a range axis for the line series, and the left axis as the range axis for the bars.

Dataset Guidelines

This chart expects its data as a categorical dataset.

Required Properties

The following properties are required:

chart-type

Code Block
XML
XML
<chart-type>BarLineChart</chart-type>

bar-series

Add one series element per series that should be plotted as bars.

Code Block
<bar-series>
  <series>actual</series>
  <series>budget</series>
</bar-series>

line-series

Add one series element per series that should be plotted as lines.

Code Block
<line-series>
  <series>variance</series>
</line-series>

The optional chart properties that are supported for this chart are listed in the Chart Properties Reference.

Example

The following chart definition will produce the chart in the example below.

Code Block
XML
XML
<chart-type>BarLineChart</chart-type>
  <bar-series>
    <series>actual</series>
    <series>budget</series>
  </bar-series>
  <line-series>
    <series>variance</series>
  </line-series>
  <border-visible>true</border-visible>
  <include-legend>false</include-legend>
  <is-3D>false</is-3D>
  <markers-visible>false</markers-visible>
  <orientation>vertical</orientation>
  <color-palette>
  		<color>#EE7733</color>
		<color>#9EAA36</color>
		<color>#BF0000</color>
		<color>#FCCF12</color>
		<color>#772200</color>
		<color>#DDCC88</color>
		<color>#123D82</color>
		<color>#4A0866</color>
		<color>#445500</color>
		<color>#FFAA00</color>
		<color>#1E8AD3</color>
		<color>#AA6611</color>
		<color>#772200</color>
  </color-palette>
  <domain-label-rotation-dir>up</domain-label-rotation-dir>
  <domain-label-rotation>0.25</domain-label-rotation>
  <lines-range-tick-format>###0.00 %</lines-range-tick-format>
  <range-tick-format>#,##0 EUR</range-tick-format>
  <lines-range-tick-font>
    <font-family>Arial</font-family>
    <size>10</size>
    <is-bold>false</is-bold>
    <is-italic>false</is-italic>
  </lines-range-tick-font>
  <range-tick-font>
    <font-family>Arial</font-family>
    <size>10</size>
    <is-bold>false</is-bold>
    <is-italic>false</is-italic>
  </range-tick-font>
  <range-title-font>
    <font-family>Arial</font-family>
    <size>10</size>
    <is-bold>false</is-bold>
    <is-italic>false</is-italic>
  </range-title-font>
  <range-title>Actual/Budget in EUR</range-title>
  <lines-range-tick-font>
    <font-family>Arial</font-family>
    <size>10</size>
    <is-bold>false</is-bold>
    <is-italic>false</is-italic>
  </lines-range-tick-font>
  <lines-range-title>Variance in %</lines-range-title>
  <lines-range-minimum>-0.1</lines-range-minimum>
  <lines-range-maximum>0.1</lines-range-maximum>
</chart>