# 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2F3b6983dc4a2e000be57e69851ab3207e417318cb.png?generation=1594659526974571\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2Fa186e8e2fb0c83999724f460bac0d9c1ba5e1a06.png?generation=1594659529895319\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2F4769e22d451fefef616207a57b4d3fcb40cf35de.gif?generation=1594659529029561\&alt=media)

### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2Fa8786886adbb618bb5756220dac50842150c4fa9.png?generation=1594659525922884\&alt=media)

In the **Series** tab you can:

1. Specify the range for a series&#x20;
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

![](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-MfCxb34YTNbjKr4pAKu%2F-MfCyemkvfP8NwOJH27I%2Fchart_series.png?alt=media\&token=b6bb6944-9728-4352-b2e6-1b6a65a68f13)

### Working with Legend and Axes

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

![](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-MfCxb34YTNbjKr4pAKu%2F-MfD-IvAFrrk8wyuLieD%2Fchart_extras.png?alt=media\&token=f03d4316-9a8d-4b95-b04d-2bb0747e4576)

#### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2F5afc96b4ecae2de2d30d2356cdb3b803440e1749.png?generation=1594659531853599\&alt=media)

#### 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2Fe9c1c1cda2b0c9265fbdce6dd45cf68eeca764e7.png?generation=1594659524919668\&alt=media)

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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2F-MfCxb34YTNbjKr4pAKu%2F-MfD-7OdMw1PcjkmF-xp%2Fyaxis-specific-settings.png?alt=media\&token=6f7fb3a9-dd41-4861-a06d-4a75eccd6d99)

## 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2Fa9b0fa142a9963bd6f396ba37cd54f4795bc08f5.png?generation=1594659533889341\&alt=media)

## 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](https://3310388157-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LEEOWDArdNNgipO8mVJ%2Fsync%2Fdb5c453ba8260b798112ce095cac60ec41782283.png?generation=1594659532834987\&alt=media)

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