- Contributed by Kamesh M
We all know that using a Bubble Graph one can show three different dimensions of data i.e, X-axis, Y-axis and the Size of the Bubble to represent an additional dimension of information for the given time period. With a small set of data this may not prove beneficial but is pretty much helpful to visually represent a large segment of data. It gives a quick impression of how the large data relate to each other in terms of for example volume, position, placement, etc among many other possibilities. All that saying, it however shows only for a certain defined time such as for a week or a month of data.
The same bubble chart can however be tweaked at large to show how the relation continues over a moving time range – say across the three months in a quarter or across twelve months in a year, which is better known as ‘Motion Chart’. And all that using the very common MS Excel itself. When the data has to be shown for different time periods using the same graph it could become a bit challenging. The idea is to show how the bubbles change with time or say any other dimension. In simple words, this can be done by using a scroll bar that would allow control the progression or the change.
Read More