Manual de sparklines
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 =...
Regístrate para leer el documento completo.