r/excel•
master_effect

[Excel 2010/2013] Bubble Chart fails to update correctly when the dataset is updated

unsolved

As I change the range of my dataset, in this case by increasing the number of months of data, the Bubble Chart fails to update accordingly. In fact, I lose data on the bubble chart (quite evident by the 3000 point losing its place).

See here: http://imgur.com/a/2TXho

Would appreciate some advice as to why this happens. I make ZERO changes. This is the default bubble graph. All I do between picture 1 and 2 is increase the selection. Picture 1 shows my initial selection.

Thanks!

Posted Jun 3, 2017, 4:56 PM UTC

10
Loading comments…