|
Stanford |
Excel |
PowerPoint |
MS Works |
KaleidaGraph |
DeltaGraph |
SigmaPlot |
Origin |
|
DATA HANDLING FACILITIES | |||||||||
Input (Keyboard, file) | K,F | K,F | K,F | K,F | K,F | K,F | K,F | K,F | |
Space, Comma, Tab delimited | S | S,C,T | S,C,T | S,C,T | S,C,T | S,C,T | S,C,T | S,C,T | |
Proprietary formats | DIF,WK3,Excel |
WKS,WK1,WK3 WKQ |
RTF,Excel |
WKS,WK1,DBF SYLK,Excel |
Excel |
WKS,WK1,WK3 WKQ,DIF,DBF SYLK,Excel |
WKS,WKQ,DBF DIF,Excel |
WKS,WK1,DBF DIF,Excel | |
Editing | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Sorting (Ascending,Descending) | D | A,D | No | A,D | A,D | A,D | A,D | A,D | |
Swap rows/columns | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Not in worksheet | |
Transformations (Maths,Algebra,Trigonometry, Bessel,Gamma,Fourier ) | M,A,T,B,G | M,A,T,F | No | M,A,T | M,A,T | M,A,T | M,A,T | M,A,T,B,G,F | |
Graph & data directly linked | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Statistical analysis | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Maximum number of variables (Data sets) | Limited by memory | 256 | 256 | 255 | 256 per page | 256 per page | 16000 | 600 per worksheet | |
Maximum number of data points per data set | Limited by memory | 16384 | 16384 | 16384 | 32000 | 32000 | 31000 | 100000+ | |
Are Missing values handled | No | Blank cell ignored | Blank cells ignored | Blank cells ignored | Blank/masked cells plot/skip | Blank cells plot/skip option | Blank cells plot/skip option | Blank cells plot/skip option? | |
Selects non-contiguous data | No | No | No | No | Yes | Yes | Yes | No | |
Interpolation (Linear, Parametric,Spline) | L,P,S | No | No | No | L,P,S | L,P,S | L,S | L,S | |
2-DIMENSIONAL DATA DISPLAY | |||||||||
Scatter (X/Y) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Line | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Hi-Low | Yes | Yes | Yes | Yes | Yes | Yes | Indirectly(error bars) | Yes | |
Bar/Column (Overlaid,stacked,total=100%,3D) | O,S,T,3D | S,3D | S,3D | S,T,3D | O,S | O,S,3D | O,S | S,3D | |
Pie (Explode,3D) | E,3D | E,3D | E,3D | E,3D | E | E,3D | E | E | |
Histogram | Yes | No | No | No | Yes | Yes | Yes | Yes | |
Area (Stacked,totals 100%,3D) | Yes | S,T,3D | S,3D | S,T,3D | No | S,T,3D | No | S | |
Bubble | Yes | No | No | No | No | Yes | No | Yes | |
Polar Graph | Yes | No | No | No | Yes | Yes | Yes | Yes | |
Vector | Yes | No | No | No | No | Yes | Yes | Yes | |
Mixed Styles (when valid) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
2D Contour | Yes | No | No | No | No | Yes | Yes | Yes | |
3-DIMENSIONAL DATA DISPLAY | |||||||||
3D scatter | Yes | No | No | No | No | Yes | Yes | Yes | |
3D Grid or regular column chart | Yes | Yes | Yes | No | No | Yes | No | Yes | |
3D histogram (X-Y) pairs | Yes | No | No | No | No | No | No | No | |
3D Surface | Yes | Yes | Yes | No | No | Yes | Yes | Yes | |
4D contour (combined surface+contour) | Yes | No | No | No | No | No | No | No | |
OTHER DISPLAY OPTIONS | |||||||||
X Error-Bars (data/function),(+/-),(asymmetric) | D/F,+ & - | D/F,+ & -,A | No | No | D/F,+ & -,A | D/F,+ & -,A | D/F,+ & -,A | D/F,+ & -,A | |
Y Error-Bars (data/function),(+/-),(asymmetric) | D/F,+ & - | D/F,+ & -,A | No | No | D/F,+ & -,A | D/F,+ & -,A | D/F,+ & -,A | D/F,+ & -,A | |
Curve fitting (Linear, Polynomial,Exponential, Logarithmic, Geometric, Hyperbolic, Fourier) | Lin,P,E,G,H | Lin,P,E,Log,G (Trendline option) | No | No | Lin,P,E,Log,G (General Fit Option) | Lin,P,E,Log,G,H | Lin,P,E,Log,G,H | Lin,P,E,Log,G,H | |
Plot maths functions | Yes | Indirectly | No | No | Yes | Yes | Yes | Yes | |
View point adjustment | Yes | No | No | No | No | Yes | No | Yes | |
Read Data points | Yes | No | No | No | No | No | No | Yes | |
CHART AXES | |||||||||
AXIS - Change width/colour | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Allow Broken or Separated Axes | Yes | No | No | No | Indirectly | Yes | Yes | Yes | |
Axis scaling user defined | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Dual X/Y-axes | Yes | Dual Y | Dual Y | Dual Y | Yes | Yes | Yes | Yes | |
Logarithmic axes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Transposition of axes | Yes | No | No | No | Yes | Yes | Yes | Yes | |
AXIS LABELLING - Allow edit of Axis titles | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Position/move Axis titles | Yes | No | No | Yes | Yes | Yes | Yes | Yes | |
Orientation of Axis titles | Horizontal,Vertical | Horizontal,Vertical | Horizontal,Vertical | Horizontal,Vertical | Horizontal/Vertical | Yes | Yes | Horizontal/Vertical | |
Scientific notation, Sub/Superscripts | Yes | No | No | No | Yes | Yes | Yes | Yes | |
Foreign character support | Yes | No | No | Yes | Yes | Yes | Yes | Yes | |
TICK MARKS - Specify position | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | |
Format options for tick mark labels | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | |
Orientation options for tick mark labels | Yes | Yes | Yes | No | Horizontal/Vertical | Yes | Yes | Yes | |
Allow labelling only every Nth tickmark | Yes | Yes | Yes | No | Yes | Yes | No | Yes | |
Grid lines on Chart | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
OTHER CHART FACILITIES | |||||||||
Titles | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Legends | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Data Point labels | Yes | Yes | No | Pie/Bar only | Line/Scat/Pie/Bar | Yes | No | Yes | |
Text annotation | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Freehand drawing annotation | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Chart size/position adjustment | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
Background composition (Coloured,Graduated,Pattern,Bitmap) | C,G,P,B | C, P | C, P | C,G.P | C | C,G,P | No | C,P | |
Frame/Bounding box | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | |
Multiple charts on page | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
CHART OBJECT ATTRIBUTES | |||||||||
Number of line styles | 5+ | <5 | 5 | 5+ | 5+ | 64 | 5+ | 5+ | |
Number of line widths (user-defined) | 5+ (u) | <5 | 5+ | 5+ | 5+ | 5+ | 5+ | 5+ (u) | |
Number of symbol styles | 5+ | 5+ | 5+ | 5+ | 5+ | 5+ | 5+ | 5+ | |
Type of fill styles (Coloured,Graduated,Pattern,Bitmap) | C,G,P,B | C, P | C, G, P, B | C,P | C,G,P | C,G,P | C,P | C,P | |
Size of pre-defined colur palette (user-defined) | 117 | 56 | 56 | 256 | 64(u) | 122(+16u) | 64(u) | 48(u) |