An Overview of Citrin 2 Features

Data brushing can be used to highlight data interrelationships.

• A powerful tool called X-zoom (X for exclude) allows walking through hierarchies of data rapidly, to discover patterns and information that are otherwise masked.

• New: X-zooming now allows walking through hierarchies of data in both directions (i.e., step-wise excluding, and step-wise return to previous states). When you use this feature, the exclusion of the data is not a visual effect. These data are excluded from the Visualization Pipeline, and hence are excluded from, for example, regression calculations.

When using scatter plots, you can generate subsets of data from selected data points, and the selections can be regular or irregular.

• Binary Scatter and Related Charts

  A binary scatter chart displays the data as a set of points on an X, Y set of coordinates. You can create different plot styles from a binary scatter plot, using connecting lines and fills, or connecting data points to origo (0.0) (New).

• X-Y, Double X/Y, and Double X-Y Scatter Series Charts

  Scatter series charts display scatter data points from one or more data series, plotted against a value axis, a category axis, or date & time.

Creating a ternary chart involves transforming three variables to ratios of three dependent proportions that are plotted in a 2-D simplex. Citrin ternary graphs provide ternary zooming support.

• Ternary Scatter Charts
• New: Displaying error regions - Citrin calculates 27 possible combinations for each ternary data point and uses the convex hull to delineate the resulting hexagonal error region.
• New: A new feature of ternary plots is the option of drawing the plot clockwise or counterclockwise.
• New: Ternary Contour

  A 2-D projection of a ternary diagram that displays values of a 4^th dimension using a color scale, contouring by triangulation.

Polar graphs can be used to display non-directional data series against variation in angles. The values of the non-directional data will be plotted proportional to the radius of the polar chart. These graphs can be plotted using geographical or geometrical angles.

• Citrin Polar Charts include three new graph types:

  New: Polar stacked area

  New: Polar stacked petal

  New: Polar scatter series

Basic heatmaps display a worksheet matrix layout using a color scale.

• New: Basic Heatmap Diagram

  In a basic heatmap diagram, the color of each cell (within the color scale applied) is determined by its values.

• New: Heatmaps With Optional Scaling of Z-Values

  This graph displays a basic heatmap, and allows representing the color-coded Z scale proportional to the corresponding cell values.

Waterfall charts are ideal for comparing variations between multiple data sets that are obtained under similar conditions.

• New: Waterfall Pseudo-Surface Charts

  In this waterfall chart type, the series are represented as a pseudo-surface.

• New: Waterfall Area and Line Series

  In the waterfall line series graph, the data series are represented using line attributes; in the waterfall area series graph, the area below the line representing each series is color-filled.

Citrin provides diverse bubble chart types, round and square bubble markers, and several options for scaling the size of bubble markers.

• New: Bubble Charts Displaying Values of a 4^th Dimension

  This graph type allows displaying values of a 4^rd variable on a bubble chart using a color-scale.

• New: Bubble Charts Displaying Values of Five Variables

  In this bubble graph, the values of the 3^rd, 4^th, and 5^th variables are represented using the bubble size, a color-scale, and value labels, respectively. For readability purposes, displaying a 5^th dimension as value labels on a bubble chart is only suitable for very small data sets.

• New: Standard Bubble Charts

  In a standard bubble chart, Citrin allow values of the bubble variable to be displayed either by the size of bubble markers or a color scale.

Spider charts, also known as radar charts, plot variations in multiple data series that represent the same factors. The multiple variables are plotted along the chart spokes (axes) from the center of the chart. Lines connect the spokes at the position of each data object, forming a spiral around the center. Each spoke represents a variable.

• Citrin Spider Charts include several graph types:

  New: Stacked area spider graphs (two types)

  New: Line spider graphs (two types)

  New: Color-filled spider

  New: A spider graph designed for data that are inherently obtained as percentage values.

  New: A spider graph designed for multiple data series whose values must be transformed into percentage while being plotted.

Citrin provides the following contouring options:

• New: Contour Matrix Graph (Map View of Regularly Spaced Data)

  This contour chart uses data in a matrix layout. Your worksheet is like a map, i.e., the matrix itself. Each cell value represents a Z value.

• New: X-Y-Z Contour Graph (Contouring by Triangulation)

  Map view of irregularly spaced data, displaying inter-related variations in values of three variables (e.g., X and Y coordinates and Z elevation).

• New: Ternary Contour (Contouring by Triangulation)

  This is a 2-D projection of a ternary diagram that displays values of a 4^th dimension using a color scale, contouring by triangulation.

Citrin provides the following column and bar charts:

• Column and Bar Charts With a Value- and a Category-Axis

  Stacked column or bar graphs compare the contribution of two or more variables to a total, across categories; clustered column or bar graphs compare values of multiple variables (displayed side-by-side), across categories.

• X-Y (Value-Axes) Column and Bar Charts

  X-Y (value axes) column and bar charts display a single-variable column/bar graph with values on both axes being treated as continuous data. In the stacked chart type, the column/bar heights represent the contribution of two or more variables to a total.

• 3-D Column, Prism, Pyramid, Band, and Area Charts

  These charts compare trends of values across series and across categories. The X-Axis represents the category axis, the data series (different variables) are arranged along the Y-Axis, and the Z-axis represents the values of data series.

Citrin provides the following area charts:

• Area Charts With a Value- and a Category-Axis

  An area graph displays the trend of values of a variable over categories or time. Stacked area graphs display the trend of contribution of values of two or more variables to the total over categories or time.

• New: X-Y (Value-Axes) Area Charts

  X-Y (value axes) area charts display a single-variable area graph with values on both axes being treated as continuous data. X-Y (value axes) stacked area graphs display the trend of contribution of values of two or more variables to the total plotted against another value axis.

These charts combine a column and a line graph, a bar and a line graph, or an area and a line graph.

• New: Combined Column-Line and Bar-Line Charts

  This graph category includes six graph types. The two charts that are combined to create these graphs have always the same category axis, but can have either one value axis or two separate ones.

• New: Combined Area-Line Charts

  This chart category includes two graph types. The area and the line charts that that are combined to create these graphs have always the same category axis, but can have either one value axis or two separate ones.

These diagrams are useful for comparing the changes in values of multiple variables across a given category axis and relative to each other. These diagrams provide 16 styles of data representation, plus automatic data processing of the value axes.

• New: Diagrams of Multiple-X Bar Graphs

  This diagram type displays multiple bar graphs each having an independent X-axis, but all sharing a common category Y-axis.

• New: Diagrams of Multiple-X Area Graphs

  This diagram type displays multiple area graphs each having an independent X-axis, but all sharing a common category Y-axis.

• New: Diagrams of Multiple-Y Column Graphs

  This diagram type displays multiple column graphs each having an independent Y-axis, but all sharing a common category X-axis.

• New: Diagrams of Multiple-Y Area Graphs

  This diagram type displays multiple area graphs each having an independent Y-axis, but all sharing a common category X-axis.

Line charts can be used to display trends of values of data series or for comparing mean values of data series or groups of data, etc.

• X-Y Line Series Charts

  These charts display trends of values of data series over time or categories, or across sorted values of a numeric variable. The options include four chart types. This graph type provides the option of breaking series lines for missing data (New).

• Double X. Double Y, and Double X-Y Line Series Charts

  For these graphs, the options include six chart types.

• Paired Line Charts

  A paired X-Y line chart displays trends of values of one or more data series, each having unique X-Y coordinates (i.e., in each series, X and Y are paired).

Some of these charts require one categorical variable; others require continuous data for both X and Y axes.

• New: High-Low and Range Charts With One Categorical Axis

  High-low chart type is used to display the high-low values of one or more data series over time or across categories. Range charts are used to show the high-low and midpoint values of one or more data series over time or across categories.

• New: XY (Values Axes) High-Low and Range Charts

  In these charts, the high-low values or high-low and midpoint values of one or more data series are plotted against a continuous variable.

• New: High-Low-Close and Open-High-Low-Close Charts

  These charts show the fluctuations in values of a given item over time, and are commonly used in market analysis.

A pie chart displays the contribution of parts to a whole.

• Pie Charts

  In a standard pie chart, the whole pie (or 100%) is a variable, and each pie slice is a part of the whole.

  Different options are available for scaling the pies when plotting more than one pie in a given chart pane; the options include radius (r) proportional to sum (linear or logarithmic), r² proportional to sum (linear or logarithmic), or r³ proportional to sum (linear or logarithmic).

• New: X-Y Scatter Pie Charts

  An X-Y scatter pie chart displays pies on an X-Y chart, i.e., each whole pie represents a worksheet row, each pie slice is a variable, and the center of each pie has a unique X-Y coordinate.

These charts are designed to display directional vectors, e.g., direction and/or speed of wind, etc. Angles should be in degrees, and can be any number (Citrin uses angle modulus 360).

• New: Vector and X-Y Vector Charts

  The chart types include angle matrix vector, radius-angle matrix vector, and X-Y vector graphs.

Visit the links below for information about statistical charts:

• Histograms of Categorical Data

  Graph types include Frequency and relative frequency (%) of categorical or nominal data, ogive, and Pareto charts

• New: Spine Chart - An Exploratory Univariate Mosaic Plot

  This chart type is a univariate mosaic plot, or a histogram in which the height of all bars is the same, while their width is proportional to the number of observations of each level of a categorical variable.

• Histograms and Bihistograms of Continuous Data

  Theses plots display frequency, relative frequency (%), or cumulative histograms of continuous data.

• Probability Charts

  Probability charts display the cumulative distribution relative to a uniform (linear) or normal distribution function.

• One-Way Box & Whisker and Box-Percentile Charts

  The box plots display rank statistics. A box-percentile plot gives the same graphical information as a box plot, but also uses width to encode information about the shape of the distributions.

  Graph type includes box & whisker and notched box & whisker, and box-percentile.

• Two-Way Clustered Box & Whisker and Box-Percentile Charts, including:

  New: Two-way box & whisker graphs

  New: Two-way notched box & whisker graphs

  New: Two-way clustered box-percentile graphs

• One-Way Mean/Median Bar and Line Charts

  These charts are for comparing mean or median values of multiple variables, represented as bar or line graphs.

  The error bar options for the mean bar/line graphs are standard error of mean, standard deviation, and confidence interval (New), including options of 90%, 95%, 97.5%, and 99%.

• Two-Way Mean/Median Charts, including:

  New: Two-way bar plots of mean and median values of response data obtained from pq levels of two experimental factors (i.e., k = pq samples/groups)

  New: Two-way line plots of mean and median values of response data obtained from pq levels of two experimental factors (i.e., k = pq samples/groups)

• Generic Survival Probability Chart

  These plots can be used for plotting cumulative survival probability data that have already been calculated.
  Note: Citrin does NOT provide survival analysis. For survival analysis, refer to Aabel Kaplan-Meier Survival Analysis.

Adding error bars to charts allows a graphical display of the statistical probability of errors, the experimental and analytical errors, etc.

The Error Bars Defined for Individual Variables

• Binary scatter plots
• Matrix Scatter diagram
• Scatter series
• Line series
• Column and bar charts (including stacked and clustered columns and bars)
• Area and stacked area charts

Error bars can be symmetrical or asymmetrical, and can be based on standard error, standard deviation, fixed values, or values of a variable (e.g., calculated errors, etc.)

For error bar examples, click here.

New: Ternary Error Regions:

• The error bars defined for individual variables can not be applied independently to a ternary chart.
• Citrin calculates 33 possible combinations for each ternary data point and uses the convex hull to delineate the resulting hexagonal error region.

To view examples, click here.

Supported Data Import Formats

• Excel format: 95, 97-2004 workbook (.xls)
• Delimited text data (tab, comma, semicolon, space, etc.)
• Fortran formatted data
• Delimited numeric matrix data
• Binary numeric matrix formats (8 bit, 16 bit, 32 bit, and 64 bit data)
• New: dBase (II, III, IV) formats

Supported Variable Types

• Numbers (any legal numerical representation with no explicit sample space)
• Date and Time (30 built-in date & time formats, and tools for custom-defining a format)
• Text (with Unicode support)

Worksheet Utilities

Quality control of numeric data

Displaying report summary statistics for each worksheet column (variable) with a single click

The worksheet notebook with two functions, (a) displaying a list of all variables present in the worksheet, and (b) a text area for storing notes, e.g., data source references, etc.

New: Hot-linking properties to worksheet columns (variables)

The Worksheet Symbol and Color Palettes

• Symbol and color palettes are used for defining markers that represent individual data objects, data groups, or the source worksheet(s) on the plotted graphs.
• A color palette is provided for coloring the values of selected cells.