Template:Data bars

Template documentation[view] [edit] [history] [purge]

Usage

This is a template for displaying a bar chart.

Simple example in the default style:

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

Berries

₆₅

₃₈

₇₂

₄₇

₂₀

₃₀

Jan

Feb

Mar

Apr

May

Jun

Total: 272

Same thing, but horizontal (style=2):

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

Berries

Jan

65

Feb

38

Mar

72

Apr

47

May

20

Jun

30

Total: 272

Given multiple data rows that look like this:

↔ Max. data columns: 16 ↔

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

↕ Max. data rows: 8 ↕

...the template displays a complex, color-keyed chart that looks like this:

₂₀₀

₁₉₀

₂₆₀

₂₀₀

₂₁₀

₁₇₀

₂₀₀

₂₆₀

₂₃₀

₂₀₀

₁₈₀

₂₁₀

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total: 2510

Apples

Bananas

Oranges

Title, Scale, Source and Alignment

Optional named parameters include title, scale and source.

A title appears bolded and centered above the chart.

A scale is needed for handling very small or large numbers.

A source tells the viewer where the data came from.

title = Small numbers, large scale

scale = 10

source = Data invented for this example.

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

Small numbers, large scale

₂₀

₁₉

₂₆

₂₀

₂₁

₁₇

Jan

Feb

Mar

Apr

May

Jun

Total: 123

Cherries

Berries

Grapes

Source: Data invented for this example.

title = Large numbers, small scale

scale = 0.1 style = 2

source = Data invented for this example.

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

Large numbers, small scale

Jul

2000

Aug

1900

Sep

2600

Oct

2000

Nov

2100

Dec

1700

Total: 12300

Apples

Bananas

Oranges

Source: Data invented for this example.

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

Berries

₆₅

₃₈

₇₂

₄₇

₂₀

₃₀

Jan

Feb

Mar

Apr

May

Jun

Total: 272

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

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:

Horizontal, with borders, shading and visible detail.

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

Fruit Amounts (lbs)

2009

₃₀₀

₇₀₀

₅₀₀

₉₀₀

2400

2010

₅₀₀

₃₀₀

₄₀₀

₇₀₀

1900

2011

₆₀₀

₁₁₀₀

₉₀₀

3200

2012

₉₀₀

₁₁₀₀

₆₀₀

₃₀₀

2900

2013

₇₀₀

₉₀₀

₇₀₀

₅₀₀

3700

2014

₆₀₀

₈₀₀

₃₀₀

2300

Total: 16400

Apples (2700)

Bananas (4100)

Oranges (3500)

Cherries (3100)

Berries (3000)

Source: Data invented for this example.

And here's exactly the same data in style=13, showing averages on the right instead of totals:

Fruit Amounts (lbs)

₂₄₀₀

900

500

700

300

₁₉₀₀

700

400

300

500

₃₂₀₀

900

1100

600

₂₉₀₀

300

600

1100

900

₃₇₀₀

500

700

900

700

₂₃₀₀

300

800

600

2009

2010

2011

2012

2013

2014

_2733.33

Apples (450)

Bananas (683.33)

Oranges (583.33)

Cherries (516.67)

Berries (500)

Average

Source: Data invented for this example.

Method

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.

The above documentation is transcluded from Template:Data bars/doc.
Editors can experiment in this template's sandbox and testcases pages.
Add categories to the /doc subpage. Subpages of this template.