Webix Spreadsheet User Guide
Search…
Introduction
SpreadSheet Basics
Working with Cells
Using Formulas for Math Calculations
Formatting Text and Cells
Formatting Text
Formatting Numbers
Formatting Dates
Working with Rows and Columns
Working with Sheets
Excel Import/Export
Printing Interface
Working with embedded Charts and Images
Powered By GitBook
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
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
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

Working with Series

Roughly speaking all default chart types can be divided into two groups:
  1. 1.
    Linear (Line, Spline, Spline Area, Area, Bar, and Radar)
  2. 2.
    Circular (Pie and Donut)
Linear and Circular Charts
You can work with a separate series of the linear charts.
In the Series tab you can:
  1. 1.
    Specify the range for a series
  2. 2.
    Choose an appropriate color from a color picker
  3. 3.
    Enable or disable tooltips for markers
  4. 4.
    Enable or disable labels for markers
  5. 5.
    Define the markers shape
  6. 6.
    Delete a series or add a new line

Working with Legend and Axes

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

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

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
Apart from the *Title* field mentioned above, the Y-axis has the several configurable options on its own:
  1. 1.
    Origin - the scale origin on the Y-axis
  2. 2.
    Start - the minimum value of the scale on the Y-Axis
  3. 3.
    End - the maximum value of the scale on the Y-Axis
  4. 4.
    Step - the scale step on the Y-Axis.
Y-axis specific options in use

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

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
You can also remove a view by selecting it and pressing the Backspace key.
Previous
Printing Interface
Last modified 11mo ago
Copy link
Contents
Adding Views to Spreadsheet
Working with Charts
Specifying Data for Charts
Working with Series
Working with Legend and Axes
Downloading Views
Removing Views from Spreadsheet