Add formulas and functions to a spreadsheet

You can perform many different types of calculations by using functions to create formulas in Google Sheets. Here's a list of all the functions available.

Use a formula

1. Open a spreadsheet.
2. Type an equal sign (=) in a cell and type in the function you want to use.
3. A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference. If you need more information, click the “Learn more” link at the bottom of the help box to open a full article.

Additional features for creating formulas

Simple ways to select and edit ranges

Range-selection mode

• When editing a formula, the range-selection signal (a grey bracket) will appear next to your cursor where you’re likely to need a range in the formula. When you see the signal, you can move the keyboard arrows around your sheet to select a range.
• Toggle this mode on and off using the keyboard shortcuts F2 or Ctrl + e. If range-selection mode is turned off, use the arrow keys to move your cursor inside the input box instead of selecting a range.
• You can also click within the sheet to select a range when editing a formula.

Range replacement

• When you have the text of a range highlighted in your formula, use F2 or Ctrl + e to enter range-selection mode and easily make adjustments to the range.
• If you press Shift + F2 or Shift + Ctrl + e while editing the text of a range, you can easily make adjustments to all occurrences of that range in the formula.

Note: You can also select ranges for your formula that are non-adjacent. To select multiple cells, click and hold Ctrlon your keyboard (Cmd on a Mac) as you select the cells you want to include in the formula.

Nested functions

A function used in the same cell with another function is called a nested function. When functions are combined, Google Sheets will calculate the innermost function first. The nested function is contained in parentheses and is used as one of the components of the surrounding function.

For example, let's say you want to calculate the absolute value of a sum of several numbers in the cell range A1:A7. To calculate the sum of these numbers, you would enter '=SUM(A1:A7)' into a cell.

To calculate the absolute value of this sum, you need to nest the sum formula within absolute value formula. To calculate both formulas in a single cell, enter '=ABS(SUM(A1:A7))' into the cell. Note that the =SUM() function is performed first and is used as a component in the =ABS() function.

Formula highlighting

When you reference other cells in a formula, those cells will be highlighted in contrasting colors to help you more easily build a formula. When you click on a cell that contains a completed formula, you'll also see these cells highlighted.

Change the formula bar size

To make the formula bar bigger or smaller, click the bottom of it, then drag it up or down.

Note: You can also use keyboard shortcuts to change the size. Click the formula bar, then click:

• PC: Ctrl + Up and Ctrl + Down 
• Mac: Ctrl + Option + Up and Ctrl + Option + Down

See the sum and average in a spreadsheet

You can quickly calculate the sum, average, and count in Google Sheets.

Note: This feature doesn’t work for some numbers or currency formats.

1. On your computer, open a spreadsheet in Google Sheets.
2. Highlight the cells you want to calculate.
3. In the bottom right, find Explore . Next to Explore, you'll see "Sum: total."
4. To see more calculations, click Sum.
   • Average
   • Minimum
   • Maximum
   • Count
   • Count numbers

See an example

	A	B
1	Student	Grade
2	Student 1	90%
3	Student 2	88%
4	Student 3	75%
5	Student 4	95%

To find the average grade:

1. Highlight the range B2:B5.
2. In the bottom right, click Sum.
3. Choose Avg.
4. In the bottom right, you’ll see “Avg: 87%.”

Reference data from other sheets

Within a single spreadsheet, you can replicate data and copy it from one sheet to another.

Get data from other sheets in your spreadsheet

1. On your computer, go to docs.google.com/spreadsheets/.
2. Open or create a sheet.
3. Select a cell.
4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 or ='Sheet number two'!B4.

Note: If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it (as in the second example).

Get data from other spreadsheets

To pull data from other spreadsheets, use the IMPORTRANGE function.

IMPORTRANGE

Imports a range of cells from a specified spreadsheet.

Sample Usage

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

IMPORTRANGE(A2,"B2")

Syntax

IMPORTRANGE(spreadsheet_key, range_string)

• spreadsheet_key - The URL of the spreadsheet from where data will be imported.
  • The value for spreadsheet_key must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.
• range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import.
  • The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet.
  • The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Notes

• Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.

See Also

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports a RSS or ATOM feed.

IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

ARRAYFORMULA

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

Sample Usage

ARRAYFORMULA(SUM(IF(A1:A10>5, A1:A10, 0)))

ARRAYFORMULA(A1:C1+A2:C2)

Syntax

ARRAYFORMULA(array_formula)

• array_formula - A range, mathematical expression using one cell range or multiple ranges of the same size, or a function that returns a result greater than one cell.

Notes

• Many array formulas will be automatically expanded into neighboring cells, obviating the explicit use of ARRAYFORMULA.
• Pressing Ctrl+Shift+Enter while editing a formula will automatically add ARRAYFORMULA( to the beginning of the formula.
• Note that array formulas cannot be exported.

See Also

ARRAY_CONSTRAIN: Constrains an array result to a specified size.

DETECTLANGUAGE

Identifies the language used in text within the specified range.

Sample Usage

DETECTLANGUAGE(A2:B7)

DETECTLANGUAGE("Bonjour")

DETECTLANGUAGE(A2)

Syntax

DETECTLANGUAGE(text_or_range)

• text_or_range - The text or reference to cells containing text to evaluate.
  • If text_or_range is specified as a range, it must be a one-dimensional column range.

Notes

• If the range specified contains multiple languages, the first text found will be evaluated.

See Also

GOOGLETRANSLATE: Translates text from one language into another.

Examples

Accepts both in-cell string and cell reference as the parameters and returns the language code.

Edge cases .

GOOGLEFINANCE

Fetches current or historical securities information from Google Finance.

Sample Usage

GOOGLEFINANCE("GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY")

GOOGLEFINANCE("GOOG","price",TODAY()-30,TODAY())

GOOGLEFINANCE(A2,A3)

Syntax

GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])

• ticker - The ticker symbol for the security to consider.
• attribute - [ OPTIONAL - "price" by default ] - The attribute to fetch about ticker from Google Finance. This is required if a date is specified.
  • attribute is one of the following for realtime data:
    • "price" - Realtime price quote, delayed by up to 20 minutes.
    • "priceopen" - The price as of market open.
    • "high" - The current day's high price.
    • "low" - The current day's low price.
    • "volume" - The current day's trading volume.
    • "marketcap" - The market capitalization of the stock.
    • "tradetime" - The time of the last trade.
    • "datadelay" - How far delayed the realtime data is.
    • "volumeavg" - The average daily trading volume.
    • "pe" - The price/earnings ratio.
    • "eps" - The earnings per share.
    • "high52" - The 52-week high price.
    • "low52" - The 52-week low price.
    • "change" - The price change since the previous trading day's close.
    • "beta" - The beta value.
    • "changepct" - The percentage change in price since the previous trading day's close.
    • "closeyest" - The previous day's closing price.
    • "shares" - The number of outstanding shares.
    • "currency" - The currency in which the security is priced.
  • attribute is one of the following for historical data:
    • "open" - The opening price for the specified date(s).
    • "close" - The closing price for the specified date(s).
    • "high" - The high price for the specified date(s).
    • "low" - The low price for the specified date(s).
    • "volume" - The volume for the specified date(s).
    • "all" - All of the above.
  • attribute is one of the following for mutual fund data:
    • "closeyest" - The previous day's closing price.
    • "date" - The date at which the net asset value was reported.
    • "returnytd" - The year-to-date return.
    • "netassets" - The net assets.
    • "change" - The change in the most recently reported net asset value and the one immediately prior.
    • "changepct" - The percentage change in the net asset value.
    • "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number.
    • "returnday" - One-day total return.
    • "return1" - One-week total return.
    • "return4" - Four-week total return.
    • "return13" - Thirteen-week total return.
    • "return52" - Fifty-two-week (annual) total return.
    • "return156" - 156-week (3-year) total return.
    • "return260" - 260-week (5-year) total return.
    • "incomedividend" - The amount of the most recent cash distribution.
    • "incomedividenddate" - The date of the most recent cash distribution.
    • "capitalgain" - The amount of the most recent capital gain distribution.
    • "morningstarrating" - The Morningstar "star" rating.
    • "expenseratio" - The fund's expense ratio.
• start_date - [ OPTIONAL ] - The start date when fetching historical data.
  • If start_date is specified but end_date|num_days is not, only the single day's data is returned.
• end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data.
• interval - [ OPTIONAL ] - The frequency of returned data; either "DAILY" or "WEEKLY".
  • interval can alternatively be specified as 1 or 7. Other numeric values are disallowed.

Notes

• All parameters must be enclosed in quotation marks or be references to cells containing text, except when interval is specified as a number and when end_date|num_days is specified as a number of days.
• Realtime results will be returned as a value within a single cell. Historical data, even for a single day, will be returned as an expanded array with column headers.
• Some attributes may not yield results for all symbols.
• If any date parameters are specified, the request is considered historical and only the historical attributes are allowed.
• GOOGLEFINANCE is only available in English and does not support most international exchanges.
• Historical data cannot be downloaded or accessed via the Sheets API or Apps Script.  If you attempt to do so, you will see a #N/A error in place of the values in the corresponding cells of your spreadsheet.

Examples

Retrieves market information from Google Finance.

Here is a list of common attributes.

Retrieves historical market information based on the specified dates from Google Finance.

Here is a list of common attributes for mutual funds.

Creates a chart inside a cell to display the currency exchange trend during the last 30 days, using the retrieving result returns by GoogleFinance.

GOOGLETRANSLATE

Translates text from one language into another.

Sample Usage

GOOGLETRANSLATE("Hello World","en","es")

GOOGLETRANSLATE(A2,B2,C2)

GOOGLETRANSLATE(A2)

Syntax

GOOGLETRANSLATE(text, [source_language, target_language])

• text - The text to translate.
  • The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• source_language - [ OPTIONAL - "auto" by default ] - The two-letter language code of the source language, e.g. "en" for English or "ko" for Korean, or "auto" to auto-detect the language.
  • If source_language is omitted, target_language must also be omitted.
• target_language - [ OPTIONAL - system language by default ] - The two-letter language code of the target language, e.g. "en" for English or "ja" for Japanese.

See Also

DETECTLANGUAGE: Identifies the language used in text within the specified range.

Examples

Translates text in the specified range from the source language into the target language.

IMAGE

Inserts an image into a cell.

Sample Usage

IMAGE("https://www.google.com/images/srpr/logo3w.png")

IMAGE(A2,2)

IMAGE(A2,4,120,200)

Syntax

IMAGE(url, [mode], [height], [width])

• url - The URL of the image, including protocol (e.g. http://).
  • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• mode - [ OPTIONAL - 1 by default ] - The sizing mode for the image
  • 1 resizes the image to fit inside the cell, maintaining aspect ratio.
  • 2 stretches or compresses the image to fit inside the cell, ignoring aspect ratio.
  • 3 leaves the image at original size, which may cause cropping.
  • 4 allows the specification of a custom size.
  • Note that no mode causes the cell to be resized to fit the image.
• height - [ OPTIONAL ] - The height of the image in pixels. mode must be set to 4 in order to set a custom height.
• width - [ OPTIONAL ] - The width of the image in pixels. mode must be set to 4 in order to set a custom width.

Examples

Inserts an image inside of a cell.

IMPORTDATA

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

Sample Usage

IMPORTDATA("http://www.census.gov/2010census/csv/pop_change.csv")

IMPORTDATA(A2)

Syntax

IMPORTDATA(url)

• url - The url from which to fetch the .csv or .tsv-formatted data, including protocol (e.g. http://).
  • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Notes

• A maximum of 50 IMPORTDATA calls are supported on a single spreadsheet.

See Also

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports a RSS or ATOM feed.

Examples

Retrieves Google office-address information from the specified CSV file URL.

IMPORTFEED

Imports a RSS or ATOM feed.

Sample Usage

IMPORTFEED("http://news.google.com/?output=atom")

IMPORTFEED(A2,B2,C2,D2)

Syntax

IMPORTFEED(url, [query], [headers], [num_items])

• url - The URL of the RSS or ATOM feed, including protocol (e.g. http://).
  • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• query - [ OPTIONAL - "items" by default ] - Specifies what data to fetch from url.
  • "feed" returns a single row containing feed information including title, description, and url.
  • "feed <type>" returns a particular attribute of the feed, where <type> is title, description, author, or url.
  • "items" returns a full table containing items from the feed. If num_items is not specified, all items currently published on the feed are returned.
  • "items <type>" returns a particular attribute of the requested item(s), where <type> is title, summary (the item content, minus hyperlinks and images), url (the URL of the individual item), or created (the post date associated with the item).
• headers - [ OPTIONAL - FALSE by default ] - Whether to include column headers as an extra row on top of the returned value.
• num_items - [ OPTIONAL ] - For queries of items, the number of items to return, starting from the most recent.
  • If num_items is not specified, all items currently published on the feed are returned.

Related articles

• IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
• IMPORTRANGE: Imports a range of cells from a specified spreadsheet.
• IMPORTHTML: Imports data from a table or list within an HTML page.
• IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTHTML

Imports data from a table or list within an HTML page.

Sample Usage

IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)

IMPORTHTML(A2,B2,C2)

Syntax

IMPORTHTML(url, query, index)

• url - The URL of the page to examine, including protocol (e.g. http://).
  • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• query - Either "list" or "table" depending on what type of structure contains the desired data.
• index - The index, starting at 1, which identifies which table or list as defined in the HTML source should be returned.
  • The indices for lists and tables are maintained separately, so there may be both a list and a table with index 1 if both types of elements exist on the HTML page.

See Also

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

IMPORTFEED: Imports a RSS or ATOM feed.

IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTRANGE

Imports a range of cells from a specified spreadsheet.

Sample Usage

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

IMPORTRANGE(A2,"B2")

Syntax

IMPORTRANGE(spreadsheet_key, range_string)

• spreadsheet_key - The URL of the spreadsheet from where data will be imported.
  • The value for spreadsheet_key must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.
• range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import.
  • The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet.
  • The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Notes

• Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.

See Also

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports a RSS or ATOM feed.

IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

IMPORTXML

Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

Sample Usage

IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing", "//a/@href")

IMPORTXML(A2,B2)

Syntax

IMPORTXML(url, xpath_query)

• url - The URL of the page to examine, including protocol (e.g. http://).
  • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
• xpath_query - The XPath query to run on the structured data.
  • For more information on XPath, see http://www.w3schools.com/xml/xpath_intro.asp.

See Also

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports a RSS or ATOM feed.

IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

QUERY function

Runs a Google Visualization API Query Language query across data.

The QUERY function offers a short, readable way to analyze data. This function uses the principles of Structured Query Language (SQL) to do searches.

Parts of a QUERY formula

A QUERY formula is formatted as =QUERY(data, query, [headers]).

Part	Description	Notes
data	The range of cells to perform the query on.	Each column of data can only hold boolean, numeric (including date/time types), or string values. In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values.
query	The query to perform, written in the Google Visualization API Query Language.	The query value can either be: Enclosed in quotation marks A reference to a cell that has the appropriate text. Learn more about the query language.
[headers]	The number of header rows at the top of data.	Headers are optional. If omitted or set to -1, the value is guessed based on the content of data.

Sample formulas

QUERY(A2:E6,"select avg(A) pivot B")

QUERY(A2:E6,F2,FALSE)

Troubleshoot problems with your formula

Try following these best practices:

• Don’t include commas between select clause functions. For example, Select B Where A is not null order by B label B ‘Student’.
• Include the third argument (headers) in your formula. If you don’t use this argument, you may see unexpected results.

Missing data when you query text and numbers

Issue

• Use a single data type (text or numbers), when using the QUERY function. If you have mixed data, the query will miss data. 

  When there is mixed data in a column:

  • The most common data type will be the data type for the query. 
  • The least common data type will be considered null values and will not be counted in the query. 

Solution

• Set the column number formatting to plain text. 

Formatting dates in a query

Issue

• When a QUERY formula refers to a date in a cell, the date is taken as a datetime number and won’t work in comparison unless it is formatted as YYYY-MM-DD. 

Solution

• If you use a date in a query, use the YYYY-MM-DD format. For example, 2017-12-31.

  Use the TEXT function to format dates like this: =query(Sheet1!D1:Z, "select D, F, Z where toDate(D) > date '" & text(A1, "yyyy-mm-dd") & "' ", 1)

Referring to columns

• There are two ways to reference a column in the QUERY function’s second argument. For most cases, you will reference a column by the column letter.

  Reference	When to use	Example
  By the letter at the top of the column.	When the source data is an explicitly referenced range (for example,  =QUERY(A:E,”select B…”))	“select B where C = ‘potato’”
  By the column index (number of columns from the left) within the data.	When the source data is an array that has been generated/computed (for example,  =QUERY({A:C,J:L},”select Col4…”)).	“select Col1 where Col2 = ‘banana’”

Using IMPORTRANGE

• Nesting an IMPORTRANGE inside a query will generate an error unless the IMPORTRANGE is run alone first to enable it to be authorized.

Examples

Example descriptions:

• • select & where: Returns rows that match the specified condition using Select and Where clauses.
  • group by: Aggregates Salary values across rows using Select and Group by clauses.
  • pivot: Transforms distinct values in columns into new columns.
  • order by: Aggregates Dept values across rows and sorts by the maximum value of Salary.
  • headers: Specifies the number of header rows in the input range, which enables transformation of multi-header rows range input to be transformed to a single row header input.

Examples

Example descriptions:

• select & where: Returns rows that match the specified condition using Select and Where clauses.
• group by: Aggregates Salary values across rows using Select and Group by clauses.
• pivot: Transforms distinct values in columns into new columns.
• order by: Aggregates Dept values across rows and sorts by the maximum value of Salary.
• headers: Specifies the number of header rows in the input range, which enables transformation of multi-header rows range input to be transformed to a single row header input.

SPARKLINE

Creates a miniature chart contained within a single cell.

Sample Usage

SPARKLINE(A1:F1)

SPARKLINE(A2:E2,{"charttype","bar";"max",40})

SPARKLINE(A2:E2,A4:B5)

SPARKLINE(A1:A5, {"charttype","column"; "axis", true; "axiscolor", "red"})

Syntax

SPARKLINE(data, [options])

• data - The range or array containing the data to plot.
• options - [ OPTIONAL ] - A range or array of optional settings and associated values used to customize the chart.
  • If referencing a range, options should be two cells wide where the first cell is the option and the second cell is the value that option is set to.
  • The "charttype" option defines the type of chart to plot, which includes:
    • "line" for a line graph (the default)
    • "bar" for a stacked bar chart
    • "column" for a column chart
    • "winloss" for a special type of column chart that plots 2 possible outcomes: positive and negative (like a coin toss, heads or tails).
  • For line graphs:
    • "xmin" sets the minimum value along the horizontal axis.
    • "xmax" sets the maximum value along the horizontal axis.
    • "ymin" sets the minimum value along the vertical axis.
    • "ymax" sets the maximum value along the vertical axis.
    • "color" sets the color of the line.
    • "empty" sets how to treat empty cells. Possible corresponding values include: "zero" or "ignore".
    • "nan" sets how to treat cells with non-numeric data. Options are: "convert" and "ignore".
    • "rtl" determines whether or not the chart is rendered right to left. Options are true or false.
    • "linewidth" determines how thick the line will be in the chart. A higher number means a thicker line.
  • For column and winloss sparklines:
    • "color" sets the color of chart columns.
    • "lowcolor" sets the color for the lowest value in the chart
    • "highcolor" sets the color for the higest value in the chart
    • "firstcolor" sets the color of the first column
    • "lastcolor" sets the color of the last column
    • "negcolor" sets the color of all negative columns
    • "empty" sets how to treat empty cells. Possible corresponding values include: "zero" or "ignore".
    • "nan" sets how to treat cells with non-numeric data. Options are: "convert" and "ignore".
    • "axis" decides if an axis needs to be drawn (true/false)
    • "axiscolor" sets the color of the axis (if applicable)
    • "ymin" sets the custom minimum data value that should be used for scaling the height of columns (not applicable for win/loss)
    • "ymax" sets the custom maximum data value that should be used for scaling the height of columns (not applicable for win/loss)
    • "rtl" determines whether or not the chart is rendered right to left. Options are true or false.
  • For bar charts:
    • "max" sets the maximum value along the horizontal axis.
    • "color1" sets the first color used for bars in the chart.
    • "color2" sets the second color used for bars in the chart.
    • "empty" sets how to treat empty cells. Possible corresponding values include: "zero" or "ignore".
    • "nan" sets how to treat cells with non-numeric data. Options are: "convert" and "ignore".
    • "rtl" determines whether or not the chart is rendered right to left. Options are true or false.

Notes

• Colors can be written using their names (e.g., "green") or as a hex code (e.g., "#3D3D3D").
• To modify the color of a line chart, change the font color of the cell.

See Also

IMAGE: Inserts an image into a cell.

GOOGLEFINANCE: Fetches current or historical securities information from Google Finance.