This article describes how to go from a table or crosstab like this:
To a Ranking (Bump) chart like the below, which shows the rank-order of each exercise frequency by month.
Requirements
- A table containing at least two rows and/or two columns. Note, if using a table created in R, be sure the statistic attribute (shown in the top left corner of the table) is present and labeled, see How to Change Table Attributes in R Tables.
Method
- From the toolbar, go to Visualization > Exotic > Bump.
- From Inputs > DATA SOURCE > Data, from the pulldown menu, select the table you want to use in the Bump chart.
- Click the page where you want to place the chart
The results are as follows:
Options
Inputs tab
DATA SOURCE
Data A 1D or 2D table with numeric data (it may contain multiple statistics, some of which may not be numeric).
Chart tab
AXIS LABELS
Show labels on axes Whether to show axis labels describing the rows and columns. Defaults to off.
BACKGROUND
Color Background color of the chart. Defaults to transparent.
NETS
Show column NET Whether to include the column NET/SUM in the chart. Defaults to off.
Show row NET Whether to include the row NET/SUM in the chart. Defaults to off.
COLUMN LABELS
Font The font settings (font name, size, bold, italics, underline and strikethrough) for the column labels. These can be changed for all the column labels at once, or for individual columns. The defaults come from the Page Master chart settings.
FORMATTING
Font The font settings (font name, size, bold, italics, underline and strikethrough) for the flow labels. These can be changed for all the flow labels at once, or for individual flows. The defaults come from the Page Master chart settings.
Show values Whether to show values at the flow labels, and if so, whether to show them to the right or below the flow labels. Defaults to "No".
NUMBER OF RANKS
Number of ranks The maximum number of ranks (flows) to be displayed. Defaults to 10.
NUMBERS
Font The font settings (font name, size, bold, italics, underline and strikethrough) for the flow indices (numbers on the left-hand side of the chart). The defaults come from the Page Master chart settings.
RANKING STATISTIC
Statistic The numeric statistic from the table to be ranked.
Minimum value If a ranking statistic value goes below this minimum value, it will be excluded from the chart.
See Also
How to Create a Palm Tree Chart