Hitachi Vantara Pentaho Community Wiki
Child pages
  • Bar-Line Combination Chart
Skip to end of metadata
Go to start of metadata

Bar\Line Combination Chart


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

<chart-type>BarLineChart</chart-type>

bar-series

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

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

line-series

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

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

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

  • No labels

5 Comments

  1. Anonymous

    My charts display nothing! can you explain how the structure of the query must be? thank you

  2. Anonymous

    Did you set the height and width of chart

  3. Is there a way to display some defined symbol say a horizontal line for the markers (line points) - requirement is no line should be displayed and the points fro plotting the line should be shown with horizontal lines.. Please advise if there is an alternative for this.

  4. Have a look at the reference, there are two properties, markers-visible and line-width, which might be able to get the job done.

    Regards,

    Ingo

  5. Thanks we have tried it. Setting<marker-visible> to true does make marker visible, however setting line-width to 0 does not hide the line fully - a faint line is still visible.