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.
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. These 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 and values. In this case, formatting is defined by your source view's fourth column of data. To use conditional formatting in scatter plots and bubble charts, follow the process in Configure conditional formatting. After updating the chart, go to the Chart tab, and expand the Series section. Toggle right on Use conditional formatting from <list item name>. The formatting displays on your chart.
On the Context tab you can toggle hierarchy filters. The hierarchy filter selector displays on the published chart, for that card on your board or worksheet. Via this filter, 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 Configure a chart card.
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 helps you to categorize the data, 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 more random in distribution, then there's low to no correlation in the data. With scatter plot and bubble charts you can:
- 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 or risks, within 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 (toggle right on Size).
A scatter plot or bubble chart may not be the best option when:
- You analyze small amounts of data
- You use non-numerical data
Anaplan's mobile app does not support scatter plot and bubble charts.