Diagrame sparkline

Opens the Sparklines Properties dialog to define sparkline settings.

To access this command...

From the menu bar:

Alege Inserează - Diagramă sparkline.

From the context menu:

Alege Diagrame sparkline - Diagrame sparkline.

From the tabbed interface:

On the Data menu of the Data tab, choose Sparklines - Sparklines.


Diagramele sparkline sunt mici diagrame afișate în interiorul unei celule.

Diagramele sparkline sunt definite pentru o celulă, dar mai multe diagrame sparkline pot fi legate împreună într-un grup. Grupul partajează aceleași proprietăți de desenare ale diagramei sparkline. Datele unice care sunt definite doar pentru o diagramă sparkline este intervalul de date care va fi folosit pentru desenarea diagramei sparkline.

Date

Input range: enter the cell range of the data. Use the shrink button to select the data range with the mouse.

Output range: select the cell range to receive the sparkline. Use the shrink button to select the cell range with the mouse.

Proprietăți

Type: select the sparkline type in the drop-down list. Choices are:

Line thickness: enter the line thickness number manually or use the spin button.

Display empty cells as: choices are available in the drop-down list:

Display hidden: check to show all columns or stacks in the range even when the data is in hidden cells. If unchecked, the hidden data is ignored.

Right-to-left: check to have the sparklines show the data in reverse order.

Culori

Series: select the main color for the sparklines.

Negative points: check and select the color for negative points.

High points: check and select the color for high points.

Low points: check and select the color for low points.

Marker: check and select the color for data points (line type only).

First point: check and select the color for first point.

Last point: check and select the color for last point.

Axe

Display X axis: check to show the X axis for sparklines.

Vertical minimum, Vertical maximum: check to set the minimum (maximum) value for the Y axis. Select one of following:

Please support us!