Template:Graph:Lines

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

This graph's main version resides at Template:Graph:Lines. Please make or suggest all the changes there, and copy it everywhere else (until the copying is automated)

This graph draws one or more independent numeric data series as lines. The data must be stored on Commons' Data namespace or come from Wikidata Query Service.

Gender pay gap

{{Graph:Lines
| table=bls.gov/US Women's weekly earnings as a percent of men's by age, annual averages.tab
| type=year | xField=year
| series="age_16_24", "age_25_34", "age_35_44", "age_45_54"
| title=Gender pay gap in the United States
| yZero=false | xAxis=Year | yAxis=Percentage | yMax=100 | yGrid=y | width=500 | legend=Age group
| vAnnotationsValues={"text": "Fictitious event", "x": 1990}
}}

See or edit raw graph data.

Paintings per decades

{{Graph:Lines
| tabletype=query | table=SELECT ?decade (COUNT(?decade) AS ?count) WHERE {
  ?item wdt:P31 wd:Q3305213 .
  ?item wdt:P571 ?inception .
  BIND( year(?inception) as ?year ). 
  BIND( ROUND(?year/10)*10 as ?decade ) .
  FILTER( ?year > 1400)
  FILTER( ?year <= year(now()))
} GROUP BY ?decade ORDER BY ?decade
| series="count" | type=year | xField=decade
|yAxisFormat=s
| yZero=false  | width=550
| title=Paintings by decade
| hAnnotationsValues={"text": "Fictitious value", "y": 20000}
}}

See or edit [[commons:data:SELECT ?decade (COUNT(?decade) AS ?count) WHERE {

 ?item wdt:P31 wd:Q3305213 .
 ?item wdt:P571 ?inception .
 BIND( year(?inception) as ?year ). 
 BIND( ROUND(?year/10)*10 as ?decade ) .
 FILTER( ?year > 1400)
   FILTER( ?year <= year(now()))

} GROUP BY ?decade ORDER BY ?decade|raw graph data]].

Population in countries bordering Germany

Wikidata query produces three columns - year, population size, and country name. This graph shows one line per country.

{{Graph:Lines
| tabletype=query | table=
#Population of countries sharing a border with Germany
SELECT ?year ?population ?countryLabel WHERE {
  {
    SELECT ?country ?year (AVG(?populations) AS ?population) WHERE {
      {
        SELECT ?country (YEAR(?date) AS ?year) ?populations WHERE {
          ?country wdt:P47 wd:Q183.
          ?country p:P1082 ?populationStatement.
          ?populationStatement ps:P1082 ?populations.
          ?populationStatement pq:P585 ?date.
        }  
      } FILTER( ?year >= 1900)
    }
    GROUP BY ?country ?year
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
| type=year | xField=year | group=countryLabel | value=population
| colorscheme=category20
| yScale=log
| legend=- | xGrid=y | yGrid=y | yTicks=7| width=600
| colorscheme=category20
|yAxisFormat=.1s
}}

See or edit [[commons:data:#Population of countries sharing a border with Germany, fixed SELECT ?year ?population ?countryLabel WHERE {

 {
   SELECT ?country ?year (AVG(?populations) AS ?population) WHERE {
     {
       SELECT ?country (YEAR(?date) AS ?year) ?populations WHERE {
         ?country wdt:P47 wd:Q183.
         ?country p:P1082 ?populationStatement.
         ?populationStatement ps:P1082 ?populations.
         ?populationStatement pq:P585 ?date.
       }
     }   FILTER( ?year >= 1900)
   }
   GROUP BY ?country ?year
 }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}|raw graph data]].

This graph draws one or more independent numeric data series as lines. The data must be stored on Commons' Data namespace or come from Wikidata Query Service.

Template parameters
Parameter		Description	Type	Status
Table type	`tabletype`	Specifies the type of the table data. "tab" (default) uses data namespace on commons, without the data: prefix. "query" sends request to wikidata query service. Default tab	String	optional
Table	`table`	Data page name on Commons, without the Data: prefix. The table should contain xField column, like year or date, and one or more series columns to plot. If tabletype parameter is set to "query", this value is the query.	String	required
X axis type	`type`	Type of the x axis - time (e.g. "2015-10" or "2013-03-08"), year (integer, but treated as a year), linear (numbers), ordinal (anything). Default year	String	suggested
X field	`xField`	Id of the data column that contains values for the X axis. If type=year, xField is also "year" by default.	String	required
Series	`series`	If each line is represented by a separate column of data (or if there is only one column), list of the data columns to show as lines. Must be in quotes, and listed by field IDs if coming from a .tab page: "field1", "field2", "field3".	String	optional
Group	`group`	If line color depends on just one column, specify that column's ID, instead of the series parameter.	String	optional
Value	`value`	If line color depends on one column, this parameter should be set to the column which has the values.	String	optional
Filter	`filter`	Optionally filter data with an template expression parameter e.g. `filter = datum.some_dataset_field > 1900 && datum.some_dataset_field < 2000` where `some_dataset_field` means some valid field of displayed dataset	String	optional
X axis starts at 0	`xAxisZero, xZero`	Force to start or not to start X axis with zero. Can be either true or false.	String	optional
Y axis zero starts at 0	`yAxisZero, yZero`	Force to start or not to start Y axis with zero. Can be either true or false.	String	optional
X axis scale clamp	`xAxisClamp`	Épingle sur l'échelle de l'axe X. Les courbes au delà de cette épingle seront cachées.	Boolean	optional
Y axis scale clamp	`yAxisClamp`	Épingle sur l'échelle de l'axe Y. Les courbes au delà de cette épingle seront cachées.	Boolean	optional
X axis minimum	`xAxisMin, xMin`	Force X axis to start from this value.	Number	optional
X axis maximum	`xAxisMax, xMax`	Force X axis to end with this value.	Number	optional
Y axis minimum	`yAxisMin, yMin`	Force Y axis to start from this value.	Number	optional
Y axis maximum	`yAxisMax, yMax`	Force Y axis to end with this value.	Number	optional
Y axis scale	`yScale`	Set Y axis scaling type - linear, log and sqrt. Default linear	String	optional
Replace zero values	`replaceZerosWith`	Replaces 0 values in Y data field. Recommended to be use alongside with yScale=log (else zeros will be filtered out).	Number	optional
Title	`title`	Title of the whole graph.	String	optional
Title horizontal alignment	`titleXAlign`	Horizontal alignment of title, could be one of: left, center, right	String	optional
Title horizontal offset	`titleXOffset`	Horizontal offset of title position, could be negative, to shift title to the left, or positive to shift title to the right	Number	optional
X axis title	`xAxisTitle`	Title of the X axis.	String	optional
Y axis title	`yAxisTitle`	Title of the Y axis.	String	optional
X axis format	`xAxisFormat`	Changes the formatting of the X axis labels Default %b %y (for dates)	String	optional
Y axis format	`yAxisFormat`	Changes the formatting of the Y axis labels Default ,d (for numbers)	String	optional
X axis labels angle	`xAxisAngle`	Rotates the x axis labels by the specified angle. Recommended values are: -45, +45, -90, +90.	Number	optional
Y axis labels angle	`yAxisAngle`	Rotates the y axis labels by the specified angle.	Number	optional
X axis labels font size	`xAxisFontSize`	no description	Number	optional
Y axis labels font size	`yAxisFontSize`	no description	Number	optional
X axis grid	`xGrid`	Show grid lines for X axis.	Boolean	optional
Y axis grid	`yGrid`	Show grid lines for Y axis.	Boolean	optional
X axis ticks	`xTicks, xAxisTicks`	How many ticks to show on X axis. 7 by default. '-' value makes it automatic. Default 7	Number	optional
Y axis ticks	`yTicks, yAxisTicks`	How many ticks to show on Y axis. Auto '-' by default. Default -	Number	optional
Raw vertical annotation values	`vAnnotationsValues`	Supply all annotation values as a list of JSON objects: {"text": "Big event", "x": 1980}, ...	String	optional
Raw horizontal annotation values	`hAnnotationsValues`	Supply all horizontal annotation values as a list of JSON objects: {"text":"Big event", "y": 980}, ...	String	optional
Vertical annotation table	`vAnnotationsTable`	Data page name on Commons, without the Data: prefix. The table must contain "x" column, and optional "text" and "color" columns.	String	optional
Horizontal annotation table	`hAnnotationsTable`	Data page name on Commons, without the Data: prefix. The table must contain "y" column, and optional "text" and "color" columns.	String	optional
Vertical annotation data transforms	`vAnnotationsTransforms`	no description	String	optional
Horizontal annotation data transforms	`hAnnotationsTransforms`	no description	String	optional
Legend	`legend`	Title of the legend. "-" shows the legend without title.	String	optional
Width	`width`	no description	Number	optional
Height	`height`	no description	Number	optional
Chart sizing mode	`chartSizing`	Chart sizing mode, could be one of: fit, pad. Use `fit` to force resulting chart canvas sizes to be exactly equal to provided width and height values. Use `pad` to define prefered plotting size with provided width and height values, and let Vega increase overall chart size to include legend and title (if any) Default fit	String	optional
Colors	`colors`	The colors of the lines, specified as a list like red, green. It has priority over colorscheme	String	optional
Color scheme	`colorscheme`	The colors of the lines, specified as Vega defined rangeliteral. Default category10	String	optional
Line width	`linewidth`	Line width for line charts or distance between the pie segments for pie charts. Default 2.5	Number	optional
Debug	`debug`	Debug output: if set, will show graph as raw JSON.	String	optional

Edit parameter translations

Wikipedia-specific options added to this template:

Parameter		Description	Type	Status
Thumbnail	`thumb`, `1`	If set, will style the chart with a border that matches that used for image thumbnails	Boolean	optional
Location	`align`, `2`	Implements the `left`, `right`, `center`, and `none` alignment options as described at image thumbnails. Defaults to `right` if `\|thumb=true`, otherwise defaults to `none`	String	optional
Caption	`caption`, `3`	Adds a caption under the image. if `\|hideSource=true`, it should include a link to the source data. Otherwise, make sure to end the caption with a period so it will display correctly with the source data after it.	String	optional
Hide source text	`hideSource`	If set, hides the "See or edit source data" text under the chart. If set, make sure to include a link to the source data elsewhere (such as in the caption).	Boolean	optional

Template calls can use the parameters by name, or they can be formatted similarly to normal image syntax. For example:

{{Graph:Lines | thumb=true | align=left
| caption=Per state GDP (via [[:Commons:Data:Bea.gov/GDP by state.tab]])
| table=Bea.gov/GDP by state.tab
| type=year | xField=year | legend=States
| series="TX","NY","CA"
| chartSizing=fit
| hideSource=true
}}

{{Graph:Lines | thumb | center | Per state GDP.
| table=Bea.gov/GDP by state.tab
| type=year | xField=year | legend=States
| series="TX","NY","CA"
| title=Per state GDP
| chartSizing=fit
}}

See or edit raw graph data.

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

<graph>

{
  //
  // ATTENTION: This code is maintained at https://www.mediawiki.org/wiki/Template:Graph:Lines
  //            Please do not modify it anywhere else, as it may get copied and override your changes.
  //            Suggestions can be made at https://www.mediawiki.org/wiki/Template_talk:Graph:Lines
  //

  "version": 2,
  "width": 300,
  "height": 200,

  "data": [{
    "name": "chart",
    "url": "tabular:///",
    "format": {"type": "json", "property": "data"

    },
    "transform": [
    	// Convert xField parameter into a field "_xfield"
    	{"type": "formula", "field": "_xfield", "expr": 
"datetime(datum.year, 0, 1)"
      },
      {"type": "fold", "fields": [{{{series}}}]}
    ]
  },
  {
    "name": "labels",
    "url": "tabular:///",
    "format": {"type": "json", "property": "schema.fields"}
  }],
  "scales": [
    {
      "name": "x",
      "type": "time",
      "domain": {"data": "chart", "field": "_xfield"},
      "range": "width",



    },
    {
      "name": "y",
      "type": "linear",
      "range": "height",
      "domain": {"data": "chart", "field": "value"},



    },
    {
      "name": "color",
      "type": "ordinal",
      "domain": {"data": "chart", "field": "key"},
      "range": "category10"
    },
    {
      "name": "labels",
      "type": "ordinal",
      "domain": {"data": "labels", "field": "name"},
      "range": {"data": "labels", "field": "title"},
    }
  ],

  "axes": [
    {"scale": "x", "type": "x", "ticks": 7


},
    {"scale": "y", "type": "y"


}
  ],

  "marks": [
    // Group data by the "key", and draw lines, one line per key
    {
      "type": "group",
      "from": {
        "data": "chart",
        "transform": [{"groupby": ["key"], "type": "facet"}]
      },
      "marks": [
        {
          "type": "line",
          "properties": {
            "enter": {
              "y": {"scale": "y", "field": "value"},
              "x": {"scale": "x", "field": "_xfield"},
              "stroke": {"scale": "color", "field": "key"},
              "interpolate": {"value": "monotone"},
              "strokeWidth": {"value": 2.5}
            }
          }
        }
      ],
    }


  ]
}

</graph>

v t e Graph, chart and plot templates
Many types	Template:Graph:Chart Module:Chart
Graph Extension	Template:Graph:Chart Template:Graph:Lines Template:Graph:Stacked Template:Map with marks
Bar	Template:Bar chart Template:Bar box Module:Bar
Line	Template:Graph:Lines
Scatter plot	Template:Dot chart
Pie chart	Template:Pie chart Template:Piechart
Tree	Template:Tree chart Template:Ahnentafel
Stacked	Template:Stacked bar
Cartogram	Template:Graph:Map Template:Global Heat Maps by Year
Color legends	Template:Legend Template:Legend-line Template:BrewerColorLegends