CHART

Description

Displays a chart based on the chart type, data, and properties that you specify. Workday recommends creating and editing charts from the user interface (

Insert

Chart

). The chart configuration panel provides significantly more functionality than this function.

Syntax

CHART(

chart_type

,

chart_data1

, [

base_properties

], [

custom_properties

], [

chart_data2

])

chart_type

: The text value representing the type of the chart to generate. Valid chart types are:

area

,

bar

,

column

,

line

, and

pie

.

chart_data1

: The primary data set to use to generate the chart. This is typically a range or any expression that returns a matrix value.

base_properties

: A set of properties that govern the display of the chart. Specify the properties using array literal syntax. Available properties vary depending on the chart type:

Area
: chart-configuration (basic, explicit, stacked, layered); interpolate (linear, curve).

Bar
: chart-configuration (basic, stacked, grouped).

Column
: chart-configuration (basic, stacked, grouped).

Line
: chart-configuration (basic, explicit); interpolate (linear, curve).

Pie
: none.

custom_properties

: Not used.

chart_data2

: Not used.

Example

Formula	Result
=CHART("line",A2:C14,{"chart-configuration", "explicit"; "interpolate", "curve"})	(Chart of data)
=CHART("area",A1:H27,{"chart-configuration", "explicit"; "interpolate", "linear"})	(Chart of data)
=CHART(IF(B17>1,"bar","pie"),Q1:R73,{"chart-configuration","basic";"interpolate","linear"})	Create a different chart type based on the current value in a particular cell. This example uses data in the sample workbook on Community.

Notes

If you include date information in the chart, make sure you use standard date/time formats; otherwise, Worksheets doesn't recognize the information as dates.

Related Functions

GROUPBY