Class ColumnChartBuilder

    Column Chart Builder

    Builder for column charts. For more details, see the Google Charts documentation .

    This example shows how to create a column chart with data from a data table.

     const 
  
 sampleData 
  
 = 
  
 Charts 
 . 
 newDataTable 
 () 
  
 . 
 addColumn 
 ( 
 Charts 
 . 
 ColumnType 
 . 
 STRING 
 , 
  
 'Year' 
 ) 
  
 . 
 addColumn 
 ( 
 Charts 
 . 
 ColumnType 
 . 
 NUMBER 
 , 
  
 'Sales' 
 ) 
  
 . 
 addColumn 
 ( 
 Charts 
 . 
 ColumnType 
 . 
 NUMBER 
 , 
  
 'Expenses' 
 ) 
  
 . 
 addRow 
 ([ 
 '2004' 
 , 
  
 1000 
 , 
  
 400 
 ]) 
  
 . 
 addRow 
 ([ 
 '2005' 
 , 
  
 1170 
 , 
  
 460 
 ]) 
  
 . 
 addRow 
 ([ 
 '2006' 
 , 
  
 660 
 , 
  
 1120 
 ]) 
  
 . 
 addRow 
 ([ 
 '2007' 
 , 
  
 1030 
 , 
  
 540 
 ]) 
  
 . 
 addRow 
 ([ 
 '2008' 
 , 
  
 800 
 , 
  
 600 
 ]) 
  
 . 
 addRow 
 ([ 
 '2009' 
 , 
  
 943 
 , 
  
 678 
 ]) 
  
 . 
 addRow 
 ([ 
 '2010' 
 , 
  
 1020 
 , 
  
 550 
 ]) 
  
 . 
 addRow 
 ([ 
 '2011' 
 , 
  
 910 
 , 
  
 700 
 ]) 
  
 . 
 addRow 
 ([ 
 '2012' 
 , 
  
 1230 
 , 
  
 840 
 ]) 
  
 . 
 build 
 (); 
 const 
  
 chart 
  
 = 
  
 Charts 
 . 
 newColumnChart 
 () 
  
 . 
 setTitle 
 ( 
 'Sales & Expenses' 
 ) 
  
 . 
 setXAxisTitle 
 ( 
 'Year' 
 ) 
  
 . 
 setYAxisTitle 
 ( 
 'Amount (USD)' 
 ) 
  
 . 
 setDimensions 
 ( 
 600 
 , 
  
 500 
 ) 
  
 . 
 setDataTable 
 ( 
 sampleData 
 ) 
  
 . 
 build 
 ();

    Methods

    Method Return type Brief description
    build()
    		Chart Builds the chart.
    reverse Categories()
    		Column Chart Builder Reverses the drawing of series in the domain axis.
    set Background Color(cssValue)
    		Column Chart Builder Sets the background color for the chart.
    set Colors(cssValues)
    		Column Chart Builder Sets the colors for the lines in the chart.
    set Data Source Url(url)
    		Column Chart Builder Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
    set Data Table(tableBuilder)
    		Column Chart Builder Sets the data table to use for the chart using a DataTableBuilder.
    set Data Table(table)
    		Column Chart Builder Sets the data table which contains the lines for the chart, as well as the X-axis labels.
    set Data View Definition(dataViewDefinition)
    		Column Chart Builder Sets the data view definition to use for the chart.
    set Dimensions(width, height)
    		Column Chart Builder Sets the dimensions for the chart.
    set Legend Position(position)
    		Column Chart Builder Sets the position of the legend with respect to the chart.
    set Legend Text Style(textStyle)
    		Column Chart Builder Sets the text style of the chart legend.
    set Option(option, value)
    		Column Chart Builder Sets advanced options for this chart.
    set Range(start, end)
    		Column Chart Builder Sets the range for the chart.
    set Stacked()
    		Column Chart Builder Uses stacked lines, meaning that line and bar values are stacked (accumulated).
    set Title(chartTitle)
    		Column Chart Builder Sets the title of the chart.
    set Title Text Style(textStyle)
    		Column Chart Builder Sets the text style of the chart title.
    set XAxis Text Style(textStyle)
    		Column Chart Builder Sets the horizontal axis text style.
    set XAxis Title(title)
    		Column Chart Builder Adds a title to the horizontal axis.
    set XAxis Title Text Style(textStyle)
    		Column Chart Builder Sets the horizontal axis title text style.
    set YAxis Text Style(textStyle)
    		Column Chart Builder Sets the vertical axis text style.
    set YAxis Title(title)
    		Column Chart Builder Adds a title to the vertical axis.
    set YAxis Title Text Style(textStyle)
    		Column Chart Builder Sets the vertical axis title text style.
    use Log Scale()
    		Column Chart Builder Makes the range axis into a logarithmic scale (requires all values to be positive).

    Detailed documentation

    build()

    Builds the chart.

    Return

    Chart — A Chart object, which can be embedded into documents, UI elements, or used as a static image.

    reverse Categories()

    Reverses the drawing of series in the domain axis. For vertical-range charts (such as line, area or column charts), this means the horizontal axis is drawn from right to left. For horizontal-range charts (such as bar charts), this means the vertical axis is drawn from top to bottom. For pie charts, this means the slices are drawn counterclockwise.

     // Creates a pie chart builder and sets drawing of the slices in a 
 // counter-clockwise manner. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newPieChart 
 (); 
 builder 
 . 
 reverseCategories 
 ();

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Background Color(cssValue)

    Sets the background color for the chart.

     // Creates a line chart builder and sets the background color to gray 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setBackgroundColor 
 ( 
 'gray' 
 );

    Parameters

    Name Type Description
    css Value
    		String The CSS value for the color (such as "blue" or "#00f" ).

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Colors(cssValues)

    Sets the colors for the lines in the chart.

     // Creates a line chart builder and sets the first two lines to be drawn in 
 // green and red, respectively. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setColors 
 ([ 
 'green' 
 , 
  
 'red' 
 ]);

    Parameters

    Name Type Description
    css Values
    		String[] An array of color CSS values, such as ["red", "#acf"] . The nth element in the array represents the color of the nth line in the chart.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Data Source Url(url)

    Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. If a data source URL and a DataTable are provided, the data source URL is ignored.

    For more information about querying data sources, check out the Google Charts documentation .

    Parameters

    Name Type Description
    url
    		String The data source URL, including any query parameters.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Data Table(tableBuilder)

    Sets the data table to use for the chart using a DataTableBuilder. This is a convenience method for setting the data table without needing to call build() .

    Parameters

    Name Type Description
    table Builder
    		Data Table Builder A data table builder. A new data table is created instantly as part of this call, so any further updates to the builder won't be reflected in the chart.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Data Table(table)

    Sets the data table which contains the lines for the chart, as well as the X-axis labels. The first column should be a string, and contain the horizontal axis labels. Any number of columns can follow, all must be numeric. Each column is displayed as a separate line.

    Parameters

    Name Type Description
    table
    		Data Table Source The data table to use for the chart.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Data View Definition(dataViewDefinition)

    Sets the data view definition to use for the chart.

    Parameters

    Name Type Description
    data View Definition
    		Data View Definition A data view definition object that defines the view that should be derived from the given data source for the chart drawing.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Dimensions(width, height)

    Sets the dimensions for the chart.

    Parameters

    Name Type Description
    width
    		Integer The width of the chart, in pixels.
    height
    		Integer The height of the chart, in pixels.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Legend Position(position)

    Sets the position of the legend with respect to the chart. By default, there is no legend.

     // Creates a line chart builder and sets the legend position to right. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setLegendPosition 
 ( 
 Charts 
 . 
 Position 
 . 
 RIGHT 
 );

    Parameters

    Name Type Description
    position
    		Position The position of the legend.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Legend Text Style(textStyle)

    Sets the text style of the chart legend.

     // Creates a line chart builder and sets it up for a  blue, 26-point legend. 
 const 
  
 textStyleBuilder 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 '#0000FF' 
 ). 
 setFontSize 
 ( 
 26 
 ); 
 const 
  
 style 
  
 = 
  
 textStyleBuilder 
 . 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setLegendTextStyle 
 ( 
 style 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the chart legend.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Option(option, value)

    Sets advanced options for this chart. See the available options for this chart . This method has no effect if the given option is invalid.

     // Build a column chart with a 1-second animation duration. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newColumnChart 
 (); 
 builder 
 . 
 setOption 
 ( 
 'animation.duration' 
 , 
  
 1000 
 ); 
 const 
  
 chart 
  
 = 
  
 builder 
 . 
 build 
 ();

    Parameters

    Name Type Description
    option
    		String The option to set.
    value
    		Object The value to set.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Range(start, end)

    Sets the range for the chart.

    If any data points fall outside the range, the range is expanded to include those data points.

    Parameters

    Name Type Description
    start
    		Number The value for the lowest grid line of the range axis.
    end
    		Number The value for the highest grid line of the range axis.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Stacked()

    Uses stacked lines, meaning that line and bar values are stacked (accumulated). By default, there is no stacking.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Title(chartTitle)

    Sets the title of the chart. The title is displayed centered above the chart.

     // Creates a line chart builder and title to 'My Line Chart'. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setTitle 
 ( 
 'My Line Chart' 
 );

    Parameters

    Name Type Description
    chart Title
    		String the chart title.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set Title Text Style(textStyle)

    Sets the text style of the chart title.

     // Creates a line chart builder and sets it up for a  blue, 26-point title. 
 const 
  
 textStyleBuilder 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 '#0000FF' 
 ). 
 setFontSize 
 ( 
 26 
 ); 
 const 
  
 style 
  
 = 
  
 textStyleBuilder 
 . 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setTitleTextStyle 
 ( 
 style 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the chart title. You can create a Text Style Builder object by calling Charts.newTextStyle() .

    Return

    Column Chart Builder — This builder, useful for chaining.

    set XAxis Text Style(textStyle)

    Sets the horizontal axis text style.

     // Creates a line chart builder and sets the X-axis text style to blue, 18-point 
 // font. 
 const 
  
 textStyle 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 'blue' 
 ). 
 setFontSize 
 ( 
 18 
 ). 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setXAxisTextStyle 
 ( 
 textStyle 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the horizontal axis title. You can create a Text Style Builder object by calling Charts.newTextStyle() .

    Return

    Column Chart Builder — This builder, useful for chaining.

    set XAxis Title(title)

    Adds a title to the horizontal axis. The title is centered and appears below the axis value labels.

     // Creates a line chart builder and sets the X-axis title. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setTitle 
 ( 
 'X-axis Title' 
 );

    Parameters

    Name Type Description
    title
    		String The title for the X-axis.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set XAxis Title Text Style(textStyle)

    Sets the horizontal axis title text style.

     // Creates a line chart builder and sets the X-axis title text style to blue, 
 // 18-point font. 
 const 
  
 textStyle 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 'blue' 
 ). 
 setFontSize 
 ( 
 18 
 ). 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setXAxisTitleTextStyle 
 ( 
 textStyle 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the horizontal axis title. You can create a Text Style Builder object by calling Charts.newTextStyle() .

    Return

    Column Chart Builder — This builder, useful for chaining.

    set YAxis Text Style(textStyle)

    Sets the vertical axis text style.

     // Creates a line chart builder and sets the Y-axis text style to blue, 18-point 
 // font. 
 const 
  
 textStyle 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 'blue' 
 ). 
 setFontSize 
 ( 
 18 
 ). 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setYAxisTextStyle 
 ( 
 textStyle 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the horizontal axis title. You can create a Text Style Builder object by calling Charts.newTextStyle() .

    Return

    Column Chart Builder — This builder, useful for chaining.

    set YAxis Title(title)

    Adds a title to the vertical axis. The title is centered and appears to the left of the value labels.

     // Creates a line chart builder and sets the Y-axis title. 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setYAxisTitle 
 ( 
 'Y-axis Title' 
 );

    Parameters

    Name Type Description
    title
    		String The title for the Y-axis.

    Return

    Column Chart Builder — This builder, useful for chaining.

    set YAxis Title Text Style(textStyle)

    Sets the vertical axis title text style.

     // Creates a line chart builder and sets the Y-axis title text style to blue, 
 // 18-point font. 
 const 
  
 textStyle 
  
 = 
  
 Charts 
 . 
 newTextStyle 
 (). 
 setColor 
 ( 
 'blue' 
 ). 
 setFontSize 
 ( 
 18 
 ). 
 build 
 (); 
 const 
  
 builder 
  
 = 
  
 Charts 
 . 
 newLineChart 
 (); 
 builder 
 . 
 setYAxisTitleTextStyle 
 ( 
 textStyle 
 );

    Parameters

    Name Type Description
    text Style
    		Text Style The text style to use for the horizontal axis title. You can create a Text Style Builder object by calling Charts.newTextStyle() .

    Return

    Column Chart Builder — This builder, useful for chaining.

    use Log Scale()

    Makes the range axis into a logarithmic scale (requires all values to be positive). The range axis are the vertical axis for vertical charts (such as line, area, or column) and the horizontal axis for horizontal charts (such as bar).

    Return

    Column Chart Builder — This builder, useful for chaining.
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: