# COLUMNSPARKLINE

## Content

This function returns a data set used for representing a column sparkline.

## Syntax

`COLUMNSPARKLINE(data, dataOrientation, [dateAxisData, dateAxisOrientation, setting])`

## Arguments

| Argument | Description |
| -------- | ----------- |
| *Data* | A range reference that represents sparkline data. For example: A1:C3. |
| *DataOrientation* | A number that represents the sparkline data orientation, 0 is vertical, 1 is horizontal. |
| *DateAxisData* | (Optional) A range reference that represents sparkline date axis data. For example: D1:F3. |
| *DateAxisOrientation* | (Optional) A number that represents the sparkline date axis orientation, 0 is vertical, 1 is horizontal. |
| *Setting* | (Optional) A string with JSON format.<br>For example: <br>`{axisColor:rgb(255,255,0),firstMarkerColor:brown,highMarkerColor:red,lastMarkerColor:blue,lowMarkerColor:green,markersColor:purple,negativeColor:yellowgreen,`<br>`seriesColor:pink,displayXAxis:true,showFirst:true,showHigh:true,showLast:true,showLow:true,showNegative:true,showMarkers:true,lineWeight:3,displayHidden:false,`<br>`displayEmptyCellsAs:1,rightToLeft:false,minAxisType:1,maxAxisType:1,manualMax:5,manualMin:-3}` |

## Data Types

Returns sparkline.

## Examples

```JavaScript
activeSheet.setFormula(2, 3, '=COLUMNSPARKLINE(B3:B14,0,A3:A14,0,"{axisColor:rgb(255,255,0),firstMarkerColor:brown,highMarkerColor:red,lastMarkerColor:blue,lowMarkerColor:green,markersColor:purple,negativeColor:yellowgreen,seriesColor:pink,displayXAxis:true,showFirst:true,showHigh:true,showLast:true,showLow:true,showNegative:true,showMarkers:true,lineWeight:3,displayHidden:false,displayEmptyCellsAs:1,rightToLeft:false,minAxisType:1,maxAxisType:1,manualMax:5,manualMin:-3}")');
```