Manual de sparklines

SPARKLINES FOR EXCEL
User manual for Version 3.4 For Microsoft Exce 2003 and 2007

Compulsory parameters in RED Contribuitors Fabrice Rimlinger Nixnut Gustavo Soto

Other parameters are optionals

Eric Gundersen Ryan Barr Lucien Mazurier

Robert Mundigl Claude-Henri Mélédo ....

http://Sparklines-excel.blogspot.com http://sourceforge.net/projects/sparklinesforxl/

Draft version 2.125/06/2009

LineChart()
=LineChart(Points1; Points2; ValMini; ValMaxi; HLine; MinZone; MaxZone; Tags; Color1; Color2;GapStyle)

Points1

Range

Black line

line OR column

Points2

Range

Blue line

Line OR Column

ValMini

Variant

ValMaxi

Variant

Hline

Variant

MinZone

Variant

MaxZone

Variant

Tags

Integer

1 4

2 6

3 7

GapStyleInteger

0 or empty = don't interpolate 1 = interpolate and show solide line 2 = interpolate and show dotted line

AreaChart()
=AreaChart(Points; Mini ; Maxi ; Line1 ; Line2 ; ColorPositive ; ColorNegative)

Points

Range

Line OR Column

Mini

Variant

Default =min(points)

Maxi

Variant

Default = max(Points)

Line1

Variant

Default color = red

Line2

VariantDefault color = Black

ColorPositive

Variant

Default = Grey

See pdf color table file for color codes

colorNegative

Variant

Default = Red

See pdf color table file for color codes

BarChart()
=BarChart(Points; Mini ; Maxi ; Line1 ; Line2 ; ColoThreshold ; ColorPositive ; ColorNegative)

Points

Range

Line OR Column

Mini

Variant

Default = min(Points)Maxi

Variant

Default=max(points)

Line1

Variant

Color Red

Line2

Variant

Color Black

ColorThreshold Variant

Default = 0

ColorPositive

Variant

Default = Grey

colorNegative

Variant

Default = red

HorizonChart()
=HorizonChart(Points; BandHeight)

Points

Range

Line OR Column

BandHeight

Variant

Best results w/ BandHeight =1/3 or 1/4 ofmax(abs(Points))

Original Areachart

Flip negative values above Zero line

Segment peaks

Compress and overlay segments

Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 7 Product 8 Product 9

70%

VariChart()
=VariChart(Variance ; Reference ; Mini ; Maxi ; Mark ; TickUnit ; Legend ; ColorPositive ; ColorNegative; Vertical )

70%

Variance

Range

Default= between -100% and +100% If > 100% the cell is completely filled

Reference

Variant

Default = 0

Mini

Variant

Default = -100%

Use it for variations > 100%

Maxi

Variant

Default = +100%

Mark

Variant

Default = None

TickUnit

Variant

Default = None

70%

Legend

Boolean

Default = False

ColorPositive

Long

Default = Green See pdf colortable file for color codes

ColorNegative

Long

Default = Red

See pdf color table file for color codes

Vertical 70%

Boolean

Default = False

HBar() & Vbar()
=VBar(Value ; ColorScheme) =HBar(Value ; ColorScheme)

Value

Variant

Has to be between -100% and +100%

Colorscheme

Long

Default = grey See pdf color table file for color codes

Vbar() A B C D E 30% 40% 20%50% 80% Hbar() For Positive values, bar starts at left of cell For Negative values, bar starts at right of cell For Negative values, bar starts at top of cell For Positive values, bar starts at bottom of cell

=If(Value (Horizontal)

13%

19%

19%

13%

BoxPlot()
=BoxPlot(Points ; BoxplotClass ; ShowAverage ; ScaleStart ; ScaleEnd ; Acceptablestart ; AcceptableEnd ; ColorScheme ;Style ; Vertical)

Points

Range

Range of cell containing all values to be described

BoxplotClass

Text

"5S"

"7S"

"Tukey"

"Bowley" "Sigma3"

Default = 5S ShowAverage Boolean Default = False

ScaleStart

Variant

Default = min(points)

ScaleEnd

Variant

Default = max(points)

AcceptableStart Variant

Default = None

AcceptableEnd

Boolean

Default =...