1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/BardotBardot
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#generative AI for data analysis
#interactive charts
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#financial modeling
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#chart
#bubble charts