> For the complete documentation index, see [llms.txt](https://interopxyz.gitbook.io/excel-plus/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://interopxyz.gitbook.io/excel-plus/components/analysis/add-spark-bar.md).

# Add Spark Bar

Adds a Spark Bar to a Range

## Description

Adds a Spark Bar to a Range

{% tabs %}
{% tab title="Preview" %}
![](https://2501927618-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe08Uu2w6ybaOmfvcxkKf%2Fuploads%2FMFQbGOXi74571YbEKLDU%2FAnalysis_SparkBar.png?alt=media\&token=e4b7ebe6-c5a6-455d-a930-2d31aa339bcd)
{% endtab %}

{% tab title="Location" %}
**Name** | Add Spark Bar

**Nickname** | SparkBar

**Tab** | ExcelPlus

**Panel** | Analysis

**Division** | 1
{% endtab %}

{% tab title="Inputs" %}
**Wks** | **Worksheet** (*worksheet*) | A Worksheet, Workbook, Range, or Worksheet Name

**Rng** | **Range** (*range*) | A Range or Address (ex. A1:B1)

**L** | **Location Range** (*range*) | A Range or Address (ex. A1:B1)

**C** | **Color** (*color*) | The Spark Bar color

**W** | **Weight** (*type*) | The Spark Bar weight
{% endtab %}

{% tab title="Outputs" %}
**Wks** | **Worksheet** (*worksheet*) | An Excel Worksheet Object
{% endtab %}

{% tab title="Mode" %}
*none*
{% endtab %}
{% endtabs %}

## Usage