How to reset overlapping chart label positioning on each refresh / with slicer use?
Hi folks, i've been working on a couple of bubble charts to track some financial derivatives/options.
I have finally gotten the charts exactly as I want them but am struggling with something I hope there is a solution for.
Along the X axis I have days to expiry for my options, the underlying data is affected by live day to day share price action, so bubbles can and do appear and dissapear independant of slowly advancing on the X axis.
The issue I have is that when refresh my charts, the labels for each bubble do not move with the bubble. Is there a way to make the label either follow the bubbles or reset their positioning on each refresh.
I have a similar issue with these charts which are linked to slicers, if I adjust the label positioning manually, if I select a different ticker on the slicer, the label does not follow the movement of the bubble.
Any thoughts or ideas?
[link] [comments]
Want to read more?
Check out the full article on the original site