# Working with embedded Charts and Images

It is possible to add and fine-tune above-cell charts and images in Spreadsheet.

## Adding Views to Spreadsheet

To add a view to SpreadSheet click the **Image** button (or **Graphs** for charts) in the **Insert** section and choose the *Add above cells* option:

![Add Image](/files/-MC86JoEvJlB7YRznhlB)

After that select an image to upload or provide a configuration for the new chart via the dialog for editing.

## Working with Charts

### Specifying Data for Charts

In order to display data in a chart you should specify the source of the cells for it. There are 2 ways to do it:

1\) Type the range of cells you want to get data from in the **Range** field:

![Range Field](/files/-MC86JoFHXb07r-bwx7H)

You can also define the left column as the X-axis or/and the top row as the legend, by checking the corresponding checkboxes.

**Note** that the range values are case-sensitive and must be in the upper-case.

2\) Put the cursor in the **Range** field and then select the area of the cells you want to get data from. The range will be calculated automatically:

![Selecting Range of Cells](/files/-MC86JoGn7_zWz7V6ByU)

### Working with Series

Roughly speaking all default chart types can be divided into two groups:

1. Linear (*Line, Spline, Spline Area, Area, Bar, Scatter and Radar*)
2. Circular (*Pie and Donut*)

![Linear and Circular Charts](/files/-MC86JoHbajWueiWrDK1)

In the **Series** tab you can:

1. Specify the range for a series
2. Choose an appropriate color from a color picker
3. Enable or disable tooltips for markers
4. Enable or disable labels for markers
5. Define the markers shape
6. Delete a series or add a new line

![](/files/-MfCyemkvfP8NwOJH27I)

### Working with Legend and Axes

In the **Extras** tab you can tune the look of the legend and axes.

![](/files/-MfD-IvAFrrk8wyuLieD)

#### Tuning Legend

To define the data source for the legend you should provide the range of the cells to get data from in the **Range** field.

It is also possible to specify the *horizontal* and *vertical alignment* of the legend via the corresponding controls.

![Legend is Located in Top Left Corner](/files/-MC86JoKApu3UKYm-Uah)

#### Tuning Axes

To define the data source for the X-axis type the range of the cells to get data from in the dedicated **Range** field.

You can also provide *titles* for both X and Y-axes. You can also provide *titles* for both axes.

![Background Lines are Colored Purple](/files/-MC86JoLeW5vU5CogCfp)

Apart from the \*Title\* field mentioned above, the Y-axis has the several configurable options on its own:

1. Origin - the scale origin on the Y-axis
2. Start - the minimum value of the scale on the Y-Axis
3. End - the maximum value of the scale on the Y-Axis
4. Step - the scale step on the Y-Axis.

![Y-axis specific options in use](/files/-MfD-7OdMw1PcjkmF-xp)

## Downloading Views

To download an image or a chart click on the menu in the right top corner of a view, mouse over the *Download* option and choose an appropriate variant:

![Download Chart](/files/-MC86JoMUWQX-U2dUsPi)

## Removing Views from Spreadsheet

In order to remove an image or a chart from SpreadSheet click on the menu in the right top corner of a view and choose the corresponding option:

![Remove Image](/files/-MC86JoNfS6a5awrDBdY)

You can also remove a view by selecting it and pressing the *Backspace* key.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://webix-guides.gitbook.io/spreadsheet-user-guide/work_with_views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
