Play Axis Visualization
You may add a time dimension to scatter and bubble charts using a PLAY AXIS to see how data changes over time. Drag a Months field with time values to the Play Axis box after selecting the bubble or scatter chart.
The bottom of the chart now has a ‘play’ button and a timeline. When you press the play button, the bubbles move, expand, and contract to indicate how the values vary depending on the play axis. You may pause at any time to examine the facts in greater depth. When you click a bubble on the chart, you can see its history in the path it has taken throughout time.
Scatter and Bubble Chart Visualization in Excel
Scatter Charts and Bubble Charts display many related data in one Chart. In both of these charts, the X – axis displays one numeric field and the Y-axis displays another. It helps to specify the relationship between two values for all the items in the chart easily. In Bubble charts, a third numeric field controls the size of the data points.