Minidiagrames

Opens the Sparklines Properties dialog to define sparklines properties.

Per a accedir a aquesta ordre...

Des de la barra de menús:

Choose Insert - Sparkline.

Des del menú contextual:

Choose Sparklines - Sparklines.

Des de la interfície en pestanyes:

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


Els minidiagrames són petits gràfics que caben dins d'una cel·la.

Sparklines are defined for one cell, but multiple sparklines can be joined together into a group. The group shares the same properties for rendering the sparkline. The unique data that is defined only for one sparkline is the data range, that a sparkline will use for rendering.

Dades

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.

Propietats

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

Gruix de la línia: intruduïu manualment el gruix de la línia o feu servir el botó de selecció de valors.

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

Mostra l'amagat: activeu aquesta opció per a mostrar totes les columnes o piles a l'interval, encara que les dades corresponents siguin a cel·les amagades. Si la casella no s'activa, s'ignoren les dades amagades al minidiagrama.

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

Colors

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.

Eixos

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:

Ens cal la vostra ajuda!