Show
OverviewA column chart is a vertical bar chart rendered in the browser using SVG or VML, whichever is appropriate for the user's browser. Like all Google charts, column charts display tooltips when the user hovers over the data. For a horizontal version of this chart, see the bar chart. ExamplesColoring columnsLet's chart the densities of four precious metals: Above, all colors are the default blue. That's because they're all part of the same series; if there were a second series, that would have been colored red. We can customize these colors with the style role: There are three different ways to choose the colors, and our data table showcases them all: RGB values, English color names, and a CSS-like declaration: var data = google.visualization.arrayToDataTable([ ['Element', 'Density', { role: 'style' }], ['Copper', 8.94, '#b87333'], // RGB value ['Silver', 10.49, 'silver'], // English color name ['Gold', 19.30, 'gold'], ['Platinum', 21.45, 'color: #e5e4e2' ], // CSS-style declaration ]); Column stylesThe style role lets your control several aspects of column appearance with CSS-like declarations:
We don't recommend that you mix styles too freely inside a chart—pick a style and stick with it—but to demonstrate all the style attributes, here's a sampler: The first two columns each use a specific function drawChart() { var data = google.visualization.arrayToDataTable([ ['Year', 'Visitations', { role: 'style' } ], ['2010', 10, 'color: gray'], ['2020', 14, 'color: #76A7FA'], ['2030', 16, 'opacity: 0.2'], ['2040', 22, 'stroke-color: #703593; stroke-width: 4; fill-color: #C5A5CF'], ['2050', 28, 'stroke-color: #871B47; stroke-opacity: 0.6; stroke-width: 8; fill-color: #BC5679; fill-opacity: 0.2'] ]); Labeling columnsCharts have several kinds of labels, such as tick labels, legend labels, and labels in the tooltips. In this section, we'll see how to put labels inside (or near) the columns in a column chart. Let's say we wanted to annotate each column with the appropriate chemical symbol. We can do that with the annotation role: In our data table, we define a new column with var data = google.visualization.arrayToDataTable([ ['Element', 'Density', { role: 'style' }, { role: 'annotation' } ], ['Copper', 8.94, '#b87333', 'Cu' ], ['Silver', 10.49, 'silver', 'Ag' ], ['Gold', 19.30, 'gold', 'Au' ], ['Platinum', 21.45, 'color: #e5e4e2', 'Pt' ] ]); While users can hover over the columns to see the data values, you might want to include them on the columns themselves: This is a little more complicated than it should be, because we create a <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", {packages:['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ["Element", "Density", { role: "style" } ], ["Copper", 8.94, "#b87333"], ["Silver", 10.49, "silver"], ["Gold", 19.30, "gold"], ["Platinum", 21.45, "color: #e5e4e2"] ]); var view = new google.visualization.DataView(data); view.setColumns([0, 1, { calc: "stringify", sourceColumn: 1, type: "string", role: "annotation" }, 2]); var options = { title: "Density of Precious Metals, in g/cm^3", width: 600, height: 400, bar: {groupWidth: "95%"}, legend: { position: "none" }, }; var chart = new google.visualization.ColumnChart(document.getElementById("columnchart_values")); chart.draw(view, options); } </script> <div id="columnchart_values" style="width: 900px; height: 300px;"></div> If we wanted to format the value differently, we could define a formatter and wrap it in a function like this: function getValueAt(column, dataTable, row) { return dataTable.getFormattedValue(row, column); } Then we could call it with If the label is too big to fit entirely inside the column, it's displayed outside: Stacked column chartsA stacked column chart is a column chart that places related values atop one another. If there are any negative values, they are stacked in reverse order below the chart's baseline. It's typically used when a category naturally divides into components. For instance, consider some hypothetical book sales, divided by genre and compared across time: You create a stacked column
chart by setting the var data = google.visualization.arrayToDataTable([ ['Genre', 'Fantasy & Sci Fi', 'Romance', 'Mystery/Crime', 'General', 'Western', 'Literature', { role: 'annotation' } ], ['2010', 10, 24, 20, 32, 18, 5, ''], ['2020', 16, 22, 23, 30, 16, 9, ''], ['2030', 28, 19, 29, 30, 12, 13, ''] ]); var options = { width: 600, height: 400, legend: { position: 'top', maxLines: 3 }, bar: { groupWidth: '75%' }, isStacked: true, }; Stacked column charts also support 100% stacking, where the stacks of elements at each domain-value are rescaled such that they add up to 100%. The options for this are Note in the 100% stacked chart on the right, the tick
values are based on the relative 0-1 scale as fractions of 1, but the axis values are displayed as percentages. This is because the percentage axis ticks are the result of applying a format of "#.##%" to the relative 0-1 scale values. When using var options_stacked = { isStacked: true, height: 300, legend: {position: 'top', maxLines: 3}, vAxis: {minValue: 0} }; var options_fullStacked = { isStacked: 'percent', height: 300, legend: {position: 'top', maxLines: 3}, vAxis: { minValue: 0, ticks: [0, .3, .6, .9, 1] } }; Creating Material column chartsIn 2014, Google announced guidelines intended to support a common look and feel across its properties and apps (such as Android apps) that run on Google platforms. We call this effort Material Design. We'll be providing "Material" versions of all our core charts; you're welcome to use them if you like how they look. Creating a Material Column Chart is similar to creating what we'll now call a "Classic" Column Chart. You load the Google Visualization API (although with the Since bar charts and column charts are essentially identical but for orientation, we call both Material Bar Charts, regardless of whether the bars are vertical
(classically, a column chart) or horizontal (a bar chart). In Material, the only difference is in the Note: Material Charts will not work in old versions of Internet Explorer. (IE8 and earlier versions don't support SVG, which Material Charts require.) Material Column Charts have many small improvements over Classic Column Charts, including an improved color palette, rounded corners, clearer label formatting, tighter default spacing between series, softer gridlines and titles (and the addition of subtitles). <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['bar']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Year', 'Sales', 'Expenses', 'Profit'], ['2014', 1000, 400, 200], ['2015', 1170, 460, 250], ['2016', 660, 1120, 300], ['2017', 1030, 540, 350] ]); var options = { chart: { title: 'Company Performance', subtitle: 'Sales, Expenses, and Profit: 2014-2017', } }; var chart = new google.charts.Bar(document.getElementById('columnchart_material')); chart.draw(data, google.charts.Bar.convertOptions(options)); } </script> </head> <body> <div id="columnchart_material" style="width: 800px; height: 500px;"></div> </body> </html> The Material Charts are in beta. The appearance and interactivity are largely final, but many of the options available in Classic Charts are not yet available in them. You can find a list of options that are not yet supported in this issue. Also, the way options are declared is not finalized, so if you are using any of the classic options, you must convert your to material options by replacing this line:
...with this:
Using Dual-Y chartsSometimes you'll want to display two series in a column chart, with two independent Y-axes: a left axis for one series, and a right axis for another: Note that not only are our two y-axes labeled differently ("parsecs" versus "apparent magnitude") but they each have their own independent scales and gridlines. If you want to customize this behavior, use the
In the code below, the <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart', 'bar']}); google.charts.setOnLoadCallback(drawStuff); function drawStuff() { var button = document.getElementById('change-chart'); var chartDiv = document.getElementById('chart_div'); var data = google.visualization.arrayToDataTable([ ['Galaxy', 'Distance', 'Brightness'], ['Canis Major Dwarf', 8000, 23.3], ['Sagittarius Dwarf', 24000, 4.5], ['Ursa Major II Dwarf', 30000, 14.3], ['Lg. Magellanic Cloud', 50000, 0.9], ['Bootes I', 60000, 13.1] ]); var materialOptions = { width: 900, chart: { title: 'Nearby galaxies', subtitle: 'distance on the left, brightness on the right' }, series: { 0: { axis: 'distance' }, // Bind series 0 to an axis named 'distance'. 1: { axis: 'brightness' } // Bind series 1 to an axis named 'brightness'. }, axes: { y: { distance: {label: 'parsecs'}, // Left y-axis. brightness: {side: 'right', label: 'apparent magnitude'} // Right y-axis. } } }; var classicOptions = { width: 900, series: { 0: {targetAxisIndex: 0}, 1: {targetAxisIndex: 1} }, title: 'Nearby galaxies - distance on the left, brightness on the right', vAxes: { // Adds titles to each axis. 0: {title: 'parsecs'}, 1: {title: 'apparent magnitude'} } }; function drawMaterialChart() { var materialChart = new google.charts.Bar(chartDiv); materialChart.draw(data, google.charts.Bar.convertOptions(materialOptions)); button.innerText = 'Change to Classic'; button.onclick = drawClassicChart; } function drawClassicChart() { var classicChart = new google.visualization.ColumnChart(chartDiv); classicChart.draw(data, classicOptions); button.innerText = 'Change to Material'; button.onclick = drawMaterialChart; } drawMaterialChart(); }; </script> </head> <body> <button id="change-chart">Change to Classic</button> <br><br> <div id="chart_div" style="width: 800px; height: 500px;"></div> </body> </html> Top-X chartsNote: Top-X axes are available only for Material charts (i.e., those with package If you want to put the X-axis labels and title on the top of your chart rather than the bottom, you can do that in Material charts with the <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['bar']}); google.charts.setOnLoadCallback(drawStuff); function drawStuff() { var data = new google.visualization.arrayToDataTable([ ['Move', 'Percentage'], ["King's pawn (e4)", 44], ["Queen's pawn (d4)", 31], ["Knight to King 3 (Nf3)", 12], ["Queen's bishop pawn (c4)", 10], ['Other', 3] ]); var options = { width: 800, legend: { position: 'none' }, chart: { title: 'Chess opening moves', subtitle: 'popularity by percentage' }, axes: { x: { 0: { side: 'top', label: 'White to move'} // Top x-axis. } }, bar: { groupWidth: "90%" } }; var chart = new google.charts.Bar(document.getElementById('top_x_div')); // Convert the Classic options to Material options. chart.draw(data, google.charts.Bar.convertOptions(options)); }; </script> </head> <body> <div id="top_x_div" style="width: 800px; height: 600px;"></div> </body> </html> Loading The google.charts.load("current", {packages: ["corechart"]}); var visualization = new google.visualization.ColumnChart(container); For Material Column Charts, the google.charts.load("current", {packages: ["bar"]}); var chart = new google.charts.Bar(container); Data formatEach row in the table represents a group of adjacent bars. Rows: Each row in the table represents a group of bars. Columns:
Configuration options
For charts that support annotations, the Type: boolean Default: true annotations.stem For charts that support annotations, the Type: object Default: color is "black"; length is 5 for domain annotations and 12 for datum annotations. annotations.style For charts that support annotations, the Type: string Default: 'point' annotations.textStyle For charts that support annotations, the var options = { annotations: { textStyle: { fontName: 'Times-Roman', fontSize: 18, bold: true, italic: true, // The color of the text. color: '#871b47', // The color of the text outline. auraColor: '#d799ae', // The transparency of the text. opacity: 0.8 } } }; This option is currently supported for area, bar, column, combo, line, and scatter charts. It is not supported by the Annotation Chart . Type: object Default: null axisTitlesPositionWhere to place the axis titles, compared to the chart area. Supported values:
Type: string Default: 'out' backgroundColor The background color for the main area of the chart. Can be either a simple HTML color string, for example: Type: string or object Default: 'white' backgroundColor.strokeThe color of the chart border, as an HTML color string. Type: string Default: '#666' backgroundColor.strokeWidthThe border width, in pixels. Type: number Default: 0 backgroundColor.fillThe chart fill color, as an HTML color string. Type: string Default: 'white' bar.groupWidthThe width of a group of bars, specified in either of these formats:
Type: number or string Default: The golden ratio, approximately '61.8%'. barsWhether the bars in a Material Bar Chart are vertical or horizontal. This option has no effect on Classic Bar Charts or Classic Column Charts. Type: 'horizontal' or 'vertical' Default: 'vertical' chartArea An object with members to configure the placement and size of the chart area (where the chart itself is drawn, excluding axis and legends). Two formats are supported: a number, or a number followed by %. A simple number is a value in pixels; a number followed by % is a percentage. Example: Type: object Default: null chartArea.backgroundColorChart area background color. When a string is used, it can be either a hex string (e.g., '#fdc') or an English color name. When an object is used, the following properties can be provided:
Type: string or object Default: 'white' chartArea.leftHow far to draw the chart from the left border. Type: number or string Default: auto chartArea.topHow far to draw the chart from the top border. Type: number or string Default: auto chartArea.widthChart area width. Type: number or string Default: auto chartArea.heightChart area height. Type: number or string Default: auto chart.subtitleFor Material Charts, this option specifies the subtitle. Only Material Charts support subtitles. Type: string Default: null chart.titleFor Material Charts, this option specifies the title. Type: string Default: null colors The colors to use for the chart elements. An array of strings, where each element is an HTML color string, for example: Type: Array of strings Default: default colors dataOpacityThe transparency of data points, with 1.0 being completely opaque and 0.0 fully transparent. In scatter, histogram, bar, and column charts, this refers to the visible data: dots in the scatter chart and rectangles in the others. In charts where selecting data creates a dot, such as the line and area charts, this refers to the circles that appear upon hover or selection. The combo chart exhibits both behaviors, and this option has no effect on other charts. (To change the opacity of a trendline, see trendline opacity .) Type: number Default: 1.0 enableInteractivityWhether the chart throws user-based events or reacts to user interaction. If false, the chart will not throw 'select' or other interaction-based events (but will throw ready or error events), and will not display hovertext or otherwise change depending on user input. Type: boolean Default: true explorer The This feature is experimental and may change in future releases. Note: The explorer only works with continuous axes (such as numbers or dates). Type: object Default: null explorer.actionsThe Google Charts explorer supports three actions:
Type: Array of strings Default: ['dragToPan', 'rightClickToReset'] explorer.axis By default, users can pan both horizontally and vertically when the Type: string Default: both horizontal and vertical panning explorer.keepInBounds By default, users can pan all around, regardless of where the data is. To ensure that users don't pan beyond the original chart, use Type: boolean Default: false explorer.maxZoomIn The maximum that the explorer can zoom in. By default, users will be able to zoom in enough that they'll see only 25% of the original view. Setting Type: number Default: 0.25 explorer.maxZoomOut The maximum that the explorer can zoom out. By default, users will be able to zoom out far enough that the chart will take up only 1/4 of the available space. Setting Type: number Default: 4 explorer.zoomDelta When users zoom in or out, Type: number Default: 1.5 focusTargetThe type of the entity that receives focus on mouse hover. Also affects which entity is selected by mouse click, and which data table element is associated with events. Can be one of the following:
In focusTarget 'category' the tooltip displays all the category values. This may be useful for comparing values of different series. Type: string Default: 'datum' fontSizeThe default font size, in pixels, of all text in the chart. You can override this using properties for specific chart elements. Type: number Default: automatic fontNameThe default font face for all text in the chart. You can override this using properties for specific chart elements. Type: string Default: 'Arial' forceIFrameDraws the chart inside an inline frame. (Note that on IE8, this option is ignored; all IE8 charts are drawn in i-frames.) Type: boolean Default: false hAxisAn object with members to configure various horizontal axis elements. To specify properties of this object, you can use object literal notation, as shown here: { title: 'Hello', titleTextStyle: { color: '#FF0000' } } Type: object Default: null hAxis.baselineThe baseline for the horizontal axis. This option is only supported for a Type: number Default: automatic hAxis.baselineColor The color of the baseline for the horizontal axis. Can be any HTML color string, for example: This option is only supported for a Type: number Default: 'black' hAxis.direction The direction in which the values along the horizontal axis grow. Specify Type: 1 or -1 Default: 1 hAxis.formatA format string for numeric or date axis labels. For number axis labels, this is a subset of the decimal formatting ICU pattern set . For instance,
For date axis labels, this is a subset of the date formatting
ICU pattern set . For instance, The actual formatting applied to the label is derived from the locale the API has been loaded with. For more details, see loading charts with a specific locale . In computing tick values and gridlines, several alternative combinations of all the relevant gridline options will be considered and alternatives will be rejected if the formatted tick labels would be duplicated or overlap. So you can specify This option is only supported for a
Type: string Default: auto hAxis.gridlinesAn object with properties to configure the gridlines on the horizontal axis. Note that horizontal axis gridlines are drawn vertically. To specify properties of this object, you can use object literal notation, as shown here: {color: '#333', minSpacing: 20} This option is only supported for a Type: object Default: null hAxis.gridlines.colorThe color of the horizontal gridlines inside the chart area. Specify a valid HTML color string. Type: string Default: '#CCC' hAxis.gridlines.count The approximate number of horizontal gridlines inside the chart area. If you specify a positive number for Type: number Default: -1 hAxis.gridlines.interval An array of sizes (as data values, not pixels) between adjacent gridlines. This option is only for numeric axes at this time, but it is analogous to the Type: number between 1 and 10, not including 10. Default: computed hAxis.gridlines.minSpacing The minimum screen space, in pixels, between hAxis major gridlines. The default for major gridlines is Type: number Default: computed hAxis.gridlines.multipleAll gridline and tick values must be a multiple of this option's value. Note that, unlike for intervals, powers of 10 times the multiple are not considered. So you can force ticks to be integers by specifying Type: number Default: 1 hAxis.gridlines.unitsOverrides the default format for various aspects of date/datetime/timeofday data types when used with chart computed gridlines. Allows formatting for years, months, days, hours, minutes, seconds, and milliseconds. General format is: gridlines: { units: { years: {format: [/*format strings here*/]}, months: {format: [/*format strings here*/]}, days: {format: [/*format strings here*/]} hours: {format: [/*format strings here*/]} minutes: {format: [/*format strings here*/]} seconds: {format: [/*format strings here*/]}, milliseconds: {format: [/*format strings here*/]}, } } Additional information can be found in Dates and Times. Type: object Default: null hAxis.minorGridlinesAn object with members to configure the minor gridlines on the horizontal axis, similar to the hAxis.gridlines option. This option is only supported for a Type: object Default: null hAxis.minorGridlines.colorThe color of the horizontal minor gridlines inside the chart area. Specify a valid HTML color string. Type: string Default: A blend of the gridline and background colors hAxis.minorGridlines.countThe Type: number Default:1 hAxis.minorGridlines.intervalThe minorGridlines.interval option is like the major gridlines interval option, but the interval that is chosen will always be an even divisor of the major gridline interval. The default interval for linear scales is Type: number Default:1 hAxis.minorGridlines.minSpacingThe minimum required space, in pixels, between adjacent minor gridlines, and between minor and major gridlines. The default value is 1/2 the minSpacing of major gridlines for linear scales, and 1/5 the minSpacing for log scales. Type: number Default:computed hAxis.minorGridlines.multipleSame as for major Type: number Default: 1 hAxis.minorGridlines.unitsOverrides the default format for various aspects of date/datetime/timeofday data types when used with chart computed minorGridlines. Allows formatting for years, months, days, hours, minutes, seconds, and milliseconds. General format is: gridlines: { units: { years: {format: [/*format strings here*/]}, months: {format: [/*format strings here*/]}, days: {format: [/*format strings here*/]} hours: {format: [/*format strings here*/]} minutes: {format: [/*format strings here*/]} seconds: {format: [/*format strings here*/]}, milliseconds: {format: [/*format strings here*/]}, } } Additional information can be found in Dates and Times. Type: object Default: null hAxis.logScale This option is only supported for a Type: boolean Default: false hAxis.scaleType
This option is only supported for a Type: string Default: null hAxis.textPositionPosition of the horizontal axis text, relative to the chart area. Supported values: 'out', 'in', 'none'. Type: string Default: 'out' hAxis.textStyleAn object that specifies the horizontal axis text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: Replaces the automatically generated X-axis ticks with the specified array. Each element of the array should be either a valid tick value (such as a number, date, datetime, or timeofday), or an object. If it's an object, it should have a The viewWindow will be automatically expanded to include the min and max ticks unless you specify a Examples:
This option is only supported for a Type: Array of elements Default: auto hAxis.title Type: string Default: null hAxis.titleTextStyleAn object that specifies the horizontal axis title text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: If false, will hide outermost labels rather than allow them to be cropped by the chart container. If true, will allow label cropping. This option is only supported for a Type: boolean Default: false hAxis.slantedText If true, draw the horizontal axis text at an angle, to help fit more text along the axis; if false, draw horizontal axis text upright. Default behavior is to slant text if it cannot all fit when drawn upright. Notice that this option is available only when the Type: boolean Default: automatic hAxis.slantedTextAngle The angle of the horizontal axis text, if it's drawn slanted. Ignored if Type: number, -90—90 Default: 30 hAxis.maxAlternationMaximum number of levels of horizontal axis text. If axis text labels become too crowded, the server might shift neighboring labels up or down in order to fit labels closer together. This value specifies the most number of levels to use; the server can use fewer levels, if labels can fit without overlapping. For dates and times, the default is 1. Type: number Default: 2 hAxis.maxTextLinesMaximum number of lines allowed for the text labels. Labels can span multiple lines if they are too long, and the number of lines is, by default, limited by the height of the available space. Type: number Default: auto hAxis.minTextSpacingMinimum horizontal spacing, in pixels, allowed between two adjacent text labels. If the labels are spaced too densely, or they are too long, the spacing can drop below this threshold, and in this case one of the label-unclutter measures will be applied (e.g, truncating the labels or dropping some of them). Type: number Default: The value of How many horizontal axis labels to show, where 1 means show every label, 2 means show every other label, and so on. Default is to try to show as many labels as possible without overlapping. Type: number Default: automatic hAxis.maxValue Moves the max value of the horizontal axis to the specified value; this will be rightward in most charts. Ignored if this is set to a value smaller than the maximum x-value of the data. This option is only supported for a Type: number Default: automatic hAxis.minValue Moves the min value of the horizontal axis to the specified value; this will be leftward in most charts. Ignored if this is set to a value greater than the minimum x-value of the data. This option is only supported for a Type: number Default: automatic hAxis.viewWindowModeSpecifies how to scale the horizontal axis to render the values within the chart area. The following string values are supported:
This option is only supported for a
Type: string Default: Equivalent to 'pretty', but Specifies the cropping range of the horizontal axis. Type: object Default: null hAxis.viewWindow.max
Ignored when Type: number Default: auto hAxis.viewWindow.min
Ignored when Type: number Default: auto heightHeight of the chart, in pixels. Type: number Default: height of the containing element isStackedIf set to true, stacks the elements for all series at each domain value. Note: In Column, Area, and SteppedArea charts, Google Charts reverses the order of legend items to better correspond with the stacking of the series elements (E.g. series 0 will be the bottom-most legend item). This does not apply to Bar Charts. The The options for
For 100% stacking, the calculated value for each element will appear in the tooltip after its actual value. The target axis will default to tick values based on the relative 0-1 scale as fractions of 1 for 100% stacking only supports data values of type Type: boolean/string Default: false legendAn object with members to configure various aspects of the legend. To specify properties of this object, you can use object literal notation, as shown here: {position: 'top', textStyle: {color: 'blue', fontSize: 16}} Type: object Default: null legend.pageIndexInitial selected zero-based page index of the legend. Type: number Default: 0 legend.positionPosition of the legend. Can be one of the following:
Type: string Default: 'right' legend.alignmentAlignment of the legend. Can be one of the following:
Start, center, and end are relative to the style -- vertical or horizontal -- of the legend. For example, in a 'right' legend, 'start' and 'end' are at the top and bottom, respectively; for a 'top' legend, 'start' and 'end' would be at the left and right of the area, respectively. The default value depends on the legend's position. For 'bottom' legends, the default is 'center'; other legends default to 'start'. Type: string Default: automatic legend.textStyleAn object that specifies the legend text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: The orientation of the chart. When set to Type: string Default: 'horizontal' reverseCategoriesIf set to true, will draw series from right to left. The default is to draw left-to-right. This option is only supported for a Type: boolean Default: false seriesAn array of objects, each describing the format of the corresponding series in the chart. To use default values for a series, specify an empty object {}. If a series or a value is not specified, the global value will be used. Each object supports the following properties:
You can specify either an array of objects, each of which applies to the series in the order given, or you can specify an object where each child has a numeric key indicating which series it applies to. For example, the following two declarations are identical, and declare the first series as black and absent from the legend, and the fourth as red and absent from the legend: series: [ {color: 'black', visibleInLegend: false}, {}, {}, {color: 'red', visibleInLegend: false} ] series: { 0:{color: 'black', visibleInLegend: false}, 3:{color: 'red', visibleInLegend: false} } Type: Array of objects, or object with nested objects Default: {} themeA theme is a set of predefined option values that work together to achieve a specific chart behavior or visual effect. Currently only one theme is available:
Type: string Default: null titleText to display above the chart. Type: string Default: no title titlePositionWhere to place the chart title, compared to the chart area. Supported values:
Type: string Default: 'out' titleTextStyleAn object that specifies the title text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: An object with members to configure various tooltip elements. To specify properties of this object, you can use object literal notation, as shown here: {textStyle: {color: '#FF0000'}, showColorCode: true} Type: object Default: null tooltip.ignoreBounds If set to Note: This only applies to HTML tooltips. If this is enabled with SVG tooltips, any overflow outside of the chart bounds will be cropped. See Customizing Tooltip Content for more details. Type: boolean Default: false tooltip.isHtmlIf set to true, use HTML-rendered (rather than SVG-rendered) tooltips. See Customizing Tooltip Content for more details. Note: customization of the HTML tooltip content via the tooltip column data role is not supported by the Bubble Chart visualization. Type: boolean Default: false tooltip.showColorCode If true, show colored squares next to the series information in the tooltip. The default is true when Type: boolean Default: automatic tooltip.textStyleAn object that specifies the tooltip text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: The user interaction that causes the tooltip to be displayed:
Type: string Default: 'focus' trendlines Displays trendlines on the charts that support them. By default, linear trendlines are used, but this can be customized with the Trendlines are specified on a per-series basis, so most of the time your options will look like this: var options = { trendlines: { 0: { type: 'linear', color: 'green', lineWidth: 3, opacity: 0.3, showR2: true, visibleInLegend: true } } } Type: object Default: null trendlines.n.colorThe color of the trendline , expressed as either an English color name or a hex string. Type: string Default: default series color trendlines.n.degree For trendlines of Type: number Default: 3 trendlines.n.labelInLegendIf set, the trendline will appear in the legend as this string. Type: string Default: null trendlines.n.lineWidthThe line width of the trendline , in pixels. Type: number Default: 2 trendlines.n.opacityThe transparency of the trendline , from 0.0 (transparent) to 1.0 (opaque). Type: number Default: 1.0 trendlines.n.pointSize Trendlines are constucted by stamping a bunch of dots on the chart; this rarely-needed option lets you customize the size of the dots. The trendline's Type: number Default: 1 trendlines.n.pointsVisible Trendlines are constucted by stamping a bunch of dots on the chart. The trendline's Type: boolean Default: true trendlines.n.showR2Whether to show the coefficient of determination in the legend or trendline tooltip. Type: boolean Default: false trendlines.n.type Whether the trendlines is Type: string Default: linear trendlines.n.visibleInLegendWhether the trendline equation appears in the legend. (It will appear in the trendline tooltip.) Type: boolean Default: false vAxes Specifies properties for individual vertical axes, if the chart has multiple vertical axes. Each child object is a To specify a chart with multiple vertical axes, first define a new axis using { series: { 2: { targetAxisIndex:1 } }, vAxes: { 1: { title:'Losses', textStyle: {color: 'red'} } } } This property can be either an object or an array: the object is a collection of objects, each with a numeric label that specifies the axis that it defines--this is the format shown above; the array is an array of objects, one per axis. For example, the following array-style notation is identical to the vAxes: [ {}, // Nothing specified for axis 0 { title:'Losses', textStyle: {color: 'red'} // Axis 1 } ] Type: Array of object, or object with child objects Default: null vAxisAn object with members to configure various vertical axis elements. To specify properties of this object, you can use object literal notation, as shown here: {title: 'Hello', titleTextStyle: {color: '#FF0000'}} Type: object Default: null vAxis.baseline Type: number Default: automatic vAxis.baselineColor Specifies the color of the baseline for the vertical axis. Can be any HTML color string, for example: Type: number Default: 'black' vAxis.direction The direction in which the values along the vertical axis grow. By default, low values are on the bottom of the chart. Specify Type: 1 or -1 Default: 1 vAxis.format A format string for numeric axis labels. This is a subset of the ICU pattern set . For instance,
The actual formatting applied to the label is derived from the locale the API has been loaded with. For more details, see loading charts with a specific locale . In computing tick values and gridlines, several alternative combinations of all the relevant gridline options will be considered and alternatives will be rejected if the formatted tick labels would be duplicated or overlap. So you can specify Type: string Default: auto vAxis.gridlinesAn object with members to configure the gridlines on the vertical axis. Note that vertical axis gridlines are drawn horizontally. To specify properties of this object, you can use object literal notation, as shown here: {color: '#333', minSpacing: 20} Type: object Default: null vAxis.gridlines.colorThe color of the vertical gridlines inside the chart area. Specify a valid HTML color string. Type: string Default: '#CCC' vAxis.gridlines.count The approximate number of horizontal gridlines inside the chart area. If you specify a positive number for Type: number Default: -1 vAxis.gridlines.interval An array of sizes (as data values, not pixels) between adjacent gridlines. This option is only for numeric axes at this time, but it is analogous to the Type: number between 1 and 10, not including 10. Default: computed vAxis.gridlines.minSpacing The minimum screen space, in pixels, between hAxis major gridlines. The default for major gridlines is Type: number Default: computed vAxis.gridlines.multipleAll gridline and tick values must be a multiple of this option's value. Note that, unlike for intervals, powers of 10 times the multiple are not considered. So you can force ticks to be integers by specifying Type: number Default: 1 vAxis.gridlines.unitsOverrides the default format for various aspects of date/datetime/timeofday data types when used with chart computed gridlines. Allows formatting for years, months, days, hours, minutes, seconds, and milliseconds. General format is: gridlines: { units: { years: {format: [/*format strings here*/]}, months: {format: [/*format strings here*/]}, days: {format: [/*format strings here*/]}, hours: {format: [/*format strings here*/]}, minutes: {format: [/*format strings here*/]}, seconds: {format: [/*format strings here*/]}, milliseconds: {format: [/*format strings here*/]} } } Additional information can be found in Dates and Times. Type: object Default: null vAxis.minorGridlinesAn object with members to configure the minor gridlines on the vertical axis, similar to the vAxis.gridlines option. Type: object Default: null vAxis.minorGridlines.colorThe color of the vertical minor gridlines inside the chart area. Specify a valid HTML color string. Type: string Default: A blend of the gridline and background colors vAxis.minorGridlines.countThe minorGridlines.count option is mostly deprecated, except for disabling minor gridlines by setting the count to 0. The number of minor gridlines depends on the interval between major gridlines (see vAxis.gridlines.interval) and the minimum required space (see vAxis.minorGridlines.minSpacing). Type: number Default: 1 vAxis.minorGridlines.intervalThe minorGridlines.interval option is like the major gridlines interval option, but the interval that is chosen will always be an even divisor of the major gridline interval. The default interval for linear scales is Type: number Default:1 vAxis.minorGridlines.minSpacingThe minimum required space, in pixels, between adjacent minor gridlines, and between minor and major gridlines. The default value is 1/2 the minSpacing of major gridlines for linear scales, and 1/5 the minSpacing for log scales. Type: number Default:computed vAxis.minorGridlines.multipleSame as for major Type: number Default: 1 vAxis.minorGridlines.unitsOverrides the default format for various aspects of date/datetime/timeofday data types when used with chart computed minorGridlines. Allows formatting for years, months, days, hours, minutes, seconds, and milliseconds. General format is: gridlines: { units: { years: {format: [/*format strings here*/]}, months: {format: [/*format strings here*/]}, days: {format: [/*format strings here*/]} hours: {format: [/*format strings here*/]} minutes: {format: [/*format strings here*/]} seconds: {format: [/*format strings here*/]}, milliseconds: {format: [/*format strings here*/]}, } } Additional information can be found in Dates and Times. Type: object Default: null vAxis.logScaleIf true, makes the vertical axis a logarithmic scale. Note: All values must be positive. Type: boolean Default: false vAxis.scaleType
This option is only supported for a Type: string Default: null vAxis.textPositionPosition of the vertical axis text, relative to the chart area. Supported values: 'out', 'in', 'none'. Type: string Default: 'out' vAxis.textStyleAn object that specifies the vertical axis text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: Replaces the automatically generated Y-axis ticks with the specified array. Each element of the array should be either a valid tick value (such as a number, date, datetime, or timeofday), or an object. If it's an object, it should have a The viewWindow will be automatically expanded to include the min and max ticks unless you specify a Examples:
Type: Array of elements Default: auto vAxis.title
Type: string Default: no title vAxis.titleTextStyleAn object that specifies the vertical axis title text style. The object has this format: { color: <string>, fontName: <string>, fontSize: <number>, bold: <boolean>, italic: <boolean> } The Type: object Default: Moves the max value of the vertical axis to the specified value; this will be upward in most charts. Ignored if this is set to a value smaller than the maximum y-value of the data. Type: number Default: automatic vAxis.minValue Moves the min value of the vertical axis to the specified value; this will be downward in most charts. Ignored if this is set to a value greater than the minimum y-value of the data. Type: number Default: null vAxis.viewWindowModeSpecifies how to scale the vertical axis to render the values within the chart area. The following string values are supported:
Type: string Default: Equivalent to
'pretty', but Specifies the cropping range of the vertical axis. Type: object Default: null vAxis.viewWindow.maxThe maximum vertical data value to render. Ignored when Type: number Default: auto vAxis.viewWindow.minThe minimum vertical data value to render. Ignored when Type: number Default: auto widthWidth of the chart, in pixels. Type: number Default: width of the containing element Methods
EventsFor more information on how to use these events, see Basic Interactivity, Handling Events, and Firing Events.
Data policyAll code and data are processed and rendered in the browser. No data is sent to any server. Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates. Last updated 2021-05-03 UTC. [{ "type": "thumb-down", "id": "missingTheInformationINeed", "label":"Missing the information I need" },{ "type": "thumb-down", "id": "tooComplicatedTooManySteps", "label":"Too complicated / too many steps" },{ "type": "thumb-down", "id": "outOfDate", "label":"Out of date" },{ "type": "thumb-down", "id": "samplesCodeIssue", "label":"Samples / code issue" },{ "type": "thumb-down", "id": "otherDown", "label":"Other" }] [{ "type": "thumb-up", "id": "easyToUnderstand", "label":"Easy to understand" },{ "type": "thumb-up", "id": "solvedMyProblem", "label":"Solved my problem" },{ "type": "thumb-up", "id": "otherUp", "label":"Other" }] What are graphics that summarize a row or column of data in a single cell?PivotTables do not contain any data themselves—they summarize data from a cell range or a table in another part of your workbook. is a graphic representation of a PivotTable.
What is the chart feature that helps identify how information is represented by colors or patterns?Chapter 6. What chart element identifies which data point or data series is represented by each color in the chart?Legend. The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different salespeople in the chart.
What is a graphic representation of trends in a data series?3. Line Graph. A line graph reveals trends or progress over time and you can use it to show many different categories of data. You should use it when you chart a continuous data set.
|