Minidiagrames

Opens the Sparklines Properties dialog to define sparkline settings.

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:

• Line: draws a line between data values.

• Column: draws a bar for each data value.

• Stacked: also known as win/loss. Displays equally sized bars indicating positive and negative values.

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:

• Gap: the missing data is not displayed. The line type discontinues in the gap and the column is not displayed.

• Zero: the missing data is displayed as value zero.

• Span: for line type only, draws a continuous line connecting the previous value to the next value.

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:

• Individual: sets automatically the minimum (maximum) value for each sparkline based on the sparkline data range values.

• Group: sets the minimum (maximum) value based on the lower and higher values found in the group of sparklines.

• Custom: enter the minimum (maximum) value for the sparkline group. Enter the minimum (maximum) values or use the spin buttons.