In Anaplan, a scatter plot displays values, along two axes, for two sets of data series. The distribution of the dots across the axes demonstrates the existence, or absence, of correlation between the events. Bubble charts, which are an added dimension of scatter plots, replace the plotted dots with bubbles. These bubbles represent a third series of data, typically meaning size or volume of a dimension related to the first two series.
Scatter plots display a series of points across horizontal and vertical axes, based on how two data series influence each other. Scatter plots are useful because they can show the extent of correlation, if any, between the observed variables. If no correlation exists between them, the points appear randomly scattered on the coordinate plane. If a large correlation exists, the points concentrate near a straight line across the axes.
Bubble charts add another dimension to scatter plots by including a third, related, series of data, which demonstrates size. This emphasizes the size of the dimension by turning the dots (plots on the chart) into bubbles. In Anaplan, the size of the bubble usually corresponds to the market size.
In both cases, a single series of data is charted from the first two columns of line items (three in the case of a bubble chart) in your grid. You may need to hide columns to establish the required adjacency.
Switch on Trendlines to more easily analyze your data. Then, you can use:
- Linear trendlines, for simple linear data sets and produces a best-fit straight line. This is used to demonstrate constant progression or decline
- Polynomial trendlines, when values fluctuate and creates an up-and-down curved line. This is used to analyze gains and losses in a large data set
- Exponential trendlines, with larger datasets with continuously fluctuating values. Due to their nature, Exponential trendlines cannot contain nonpositive (greater-than-zero) values in the Y-axis and will be unavailable if these values are present
- Logarithmic trendlines, to facilitate the display of sudden increases or decreases in the trend, but tend to level out. Due to their nature, Logarithmic trendlines cannot contain nonpositive (greater-than-zero) values in the Z-axis and will be unavailable if these values are present
Scatter plots and bubble charts can also use conditional formatting. This allows you to set statuses to color the bubble or plot markers based on rules. In this case, formatting is defined by your source view's fourth column of data.
On the Context tab you can toggle Hierarchy filters. The hierarchy filter selector displays on the published chart, beside other context selectors for that card on your board or worksheet. Through this, users can navigate different branches of the list hierarchy in the source model.
To learn how to add a scatter plot or bubble chart to a board or worksheet, see:
Use of scatter plot and bubble charts
The scatter plot and bubble chart are best used when comparing paired numerical data, not necessarily associated to a time dimension. The plot of markers across the visualization will allow you to extrapolate the displayed data and derive conclusions based on your use case. If the markers are grouped tightly together, then there's a high correlation. If the markers on the chart are apparently random in distribution, then there's low to no correlation in the data. You can do the following with this type of chart:
- Determine the root cause of a given scenario, by comparing numerical data
- Visualize the relationship between your two data series
- Identify where or who are the outliers in the data set
- Determine a trend in the correlation of data
- Identify opportunities and/or risk vs. return, in a competitive scenario
Apart from generic chart configuration options, scatter plot and bubble charts have unique configuration options and requirements. These include:
- Define minimum and maximum values for the chart axes
- Create a bubble chart via the Card Configuration Chart tab, by toggling right on Size
A scatter plot or bubble chart may not be the best option when:
- you're handling a small amount of data
- you're handling non-numerical data
Anaplan's mobile app does not support scatter plot and bubble charts.