Looking for line fills?
chm parameter can also be used for line fills in line charts
Compound charts are only enabled in Enterprise+ subscriptions
You can combine several chart types with line markers to highlight data trends or show variance. When you add line markers onto bar, scatter, or other chart types, the resulting chart is called a compound chart. Some compound charts look like a combination of two chart types—for instance, a bar chart with a tracking line:
Creating a Compound Chart (Mixed Charts)
All compound charts consist of one or more base chart types (line, scatter, bar, or radar) combined with one or more sets of markers. These markers require data to place them on the chart. Sometimes you can use the same data series as used to draw the bars or points on your chart, but typically you want the markers to have their own independent data sets. If you want your chart to have different data series for the base chart and for markers, you must hide the marker data from the base chart (so that it doesn't try to draw more bars or lines with that data). Here's how to do that:
- Add your marker data series to the end of your
chdparameter. For example, if your bar chart had data
chd=t:30,10,20, you could add new data for a line marker like this:
- Hide your extra marker data from the base chart. If you simply add an extra data series to a bar chart for your tracking line, the chart would show that as a new series of bars. To prevent this, you must hide this extra series. To hide a series, include a single digit after the
chdformat descriptor: for example,
t1tells the Chart API how many data series to use to draw elements for that base chart type as defined by the cht parameter (bars for bar charts, data points for line charts, and so on). Any additional data series will be ignored by that chart type when drawing the chart.
Note that this is a 1-based number, not 0-based. So
t1means "use only the first data series for bars,"
t2means "use only the first two series for bars," etc.
- Use the hidden data series to draw line markers, or other markers. How to draw markers is covered in the section below. Reference the hidden data series as the source for your markers. You can include as many additional hidden data series as you like, and use them for additional chart markers.
cht=bvg chd=t1:30,10,20|60,40,50 chm=D,0033FF,1,0,5,1
DIndicates that this is a line marker.
<color>The color of the line, in RRGGBB hexadecimal format.
<series_index>The index of the data series used to draw the line. The data series index is 0 for the first data series, 1 for the second data series, and so on.
<which_points>Which points in a series to use to draw the line. Use one of the following values:
0- Use all the points in the series.
start:end- Use a specific range of points in the series, from the start to end, inclusive (zero-based index). You can also use floating point values to specify intermediate points, or leave start or end blank to indicate the first or last data point, respectively. start and end can be negative, as a reverse index from the last value. If both start and end are negative, be sure to write them in increasing value (for example, -6:-1).
<size>The width of the line in pixels.
To add multiple lines (or combine this with any other
chm markers), separate the
chm parameter sets using a pipe ( | ) delimiter. You cannot make a dashed line marker with this parameter.
Bar line with line serie
Here is a bar chart with a trace line. The first two data series are used for the stacked bars, and the remaining series is used for the line. chd=s2 indicates that the chart should use only the first two series for bars. The line uses the third series for its data.
chd=s2:1XQbnf4,EWoQMUB,9halxp9- Simple encoding, where the first two series are used to draw the bars, and the last series is used for the line.
chm=D,0033FF,2,0,5,1- Trace line (D), blue, data from series index 2, all points (0), line is 5 pixels wide, and has a z-order of 1.
chm= D,0033FF,2,0,5,1 chd=s2: 1XQbnf4, EWoQMUB, 9halxp9
Stacked bar chart with an independent line drawn
cht=bvs chd=t2: 0,10,20,30,20,70,80| 0,20,10,5,20,30,10| 10,0,20,15,60,40,30 chm=D,76A4FB,2,0,3