Contents

Template:Data bars

{{Data bars
| columns =6| Jan| Feb| Mar| Apr| May| Jun
| blue|Berries|65|38|72|47|20|30}}

{{Data bars
| style =2| columns =6| Jan| Feb| Mar| Apr| May| Jun
| blue|Berries|65|38|72|47|20|30}}

{{Data bars
| columns =12|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec
| green|  Apples|60|70|90|30|50|30|100|130|120|90|50|110
|yellow| Bananas|90|80|110|60|70|80|70|70|40|50|50|60|orange| Oranges|50|40|60|110|90|60|30|60|70|60|80|40}}

Title, Scale, Source and Alignment[edit]

Optional named parameters include title, scale and source.

Atitle appears bolded and centered above the chart.

Ascale is needed for handling very small or large numbers.

Asource tells the viewer where the data came from.

{{Data bars
| title = Small numbers, large scale
| scale =10| source = Data invented for this example.
| columns =6|Jan|Feb|Mar|Apr|May|Jun
|   red|Cherries|6|7|9|3|5|3|  blue| Berries|9|8|11|6|7|8|purple|  Grapes|5|4|6|11|9|6}}

{{Data bars
| title = Large numbers, small scale
| scale = 0.1 | style =2| source = Data invented for this example.
| columns =6| Jul| Aug| Sep| Oct| Nov| Dec
| green|  Apples| 600| 700| 900| 300| 500| 300
|yellow| Bananas| 900| 800|1100| 600| 700| 800
|orange| Oranges| 500| 400| 600|1100| 900| 600
}}

Also, to center or to float a chart left or right, specify center, rightorleft in parameter align (aka float). For example:

{{Data bars
| align = right
| columns =6| Jan| Feb| Mar| Apr| May| Jun
| blue|Berries|65|38|72|47|20|30}}

Orientation, Borders, Details and Averages[edit]

There are sixteen styles to choose from.

Odd numbered styles are vertical.

Even numbered styles are horizontal.

Styles 3 and 4 have borders and shading.

Styles 5 thru 8 are the same as 1 thru 4, but show additional detail.

Styles 9 thru 16 are the same as 1 thru 8, but averages are displayed with the color key, instead of totals.

For example, here's one using style=8:

{{Data bars
| style  =8| scale  = 0.1
| title  = Fruit Amounts (lbs)
| source = Data invented for this example.
| columns =6|2009|2010|2011|2012|2013|2014
| green|  Apples|    | 700| 900| 300| 500| 300
|yellow| Bananas| 900|    |1100| 600| 700| 800
|orange| Oranges| 500| 400|    |1100| 900| 600
|   red|Cherries| 700| 300| 600|    | 900| 600
|  blue| Berries| 300| 500| 600| 900| 700| 
}}

Method[edit]

This template employs five "sub-templates." A table is created using the columns and rows of data.

{{Data bars/bar}} draws each vertical or horizontal rectangle optionally colored and labeled with a name and/or a value.

{{Data bars/column}} handles one column of data.

If style is > 8, the data is passed along to other sub-templates to display averages instead of totals with the color key.

{{Data bars/averages}} calculates the averages of all the rows of data.

{{Data bars/averages/display}} assigns the averages to named parameters for display as a single complex bar.

{{Data bars/averages/column}} draws a vertical labeled bar of averages serving as a color key.