Draw As (drawAs)

The Draw As property specifies the type of chart rendered from the data.

In the Properties view, this property is the Draw As property in the Chart category.

Type: Enum.

Map chart

Table 1 shows valid values for drawAs for the map chart. The default is a Pie.
Table 1. Map Chart DrawAs values
Name
Bar
Bar3D
Pie
Pie3D
Ring

You can also specify that the map chart displays as a table by setting drawAs to Table, SortedTable, or AggregatedTable.

Category chart

Table 2 shows valid values for drawAs for Category Chart. The default is a Bar.
Table 2. Category Chart DrawAs values
Name
Area
Bar
Bar3D
Line
Line3D
SpiderWeb
StackedArea
StackedBar
Waterfall

You can also specify that the category chart displays as a table by setting drawAs to Table, SortedTable, or AggregatedTable.

Note: Spider web charts are also known as radar charts.
Note: If you select Waterfall as the chart type, the value in the last category of the data set should be (redundantly) specified as the sum of the items in the preceding categories - otherwise, the final bar in the chart will be incorrectly plotted. At the present time, the chart can only have one category.

XY chart

Table 3 shows valid values for drawAs for XY Chart. The default is a Line.
Table 3. XY Chart DrawAs values
Name
Area
Line
Polar
Scatter
StackedArea
Step
StepArea
TimeSeries

You can also specify that the XY chart displays as a table by setting drawAs to Table or SortedTable.

Pivot table

Table 4 shows valid values for drawAs for Pivot Table. The default is a Table.
Table 4. Pivot Table DrawAs values
Name
Area Bar Bar3D
Line Line3D Pie
Pie3D Polar Ring
Scatter SpiderWeb StackedArea
StackedBar Step StepArea
Table TimeSeries Waterfall
XYArea XYStacked XYLine

The drawAs property specifies the type of output that is rendered from the data. Depending on the type selected and the number of available dimensions, the rendering is delegated to the map chart, category chart, XY chart, or table element. If the number of selected dimensions outnumbers the respective number in the selected visualization, the exceeding dimensions and measures are ignored. The values are assigned from left to right. For example, if a pivot table with 4 dimensions and 3 measures is drawn as a category chart with only 2 dimensions and one measure, then the chart is drawn using the first two dimensions and the first measure from the pivot table's columns. Selecting Table causes the output to be drawn in tabular form, displaying all selected columns of the pivot table.