The problem /u/BardotBardot describes is not a minor annoyance. It is the exact reason that static spreadsheet tools fail when data moves in real time. Labels that stay pinned to yesterday's coordinates are not a bug, they are a symptom of a tool built for snapshots, not for live, dynamic datasets. If your bubble chart tracks options that appear and disappear based on daily share price action, then every refresh should feel like a fresh canvas, not a manual repair job.
We see this frustration constantly. Users spend hours perfecting a chart's layout, only to watch it break the moment new data arrives. The labels drift, bubbles shift, and suddenly the visual story you built is misleading. For anyone managing financial derivatives, that risk is unacceptable. A chart that requires manual label repositioning after each refresh isn't saving you time, it's costing you trust in your own data. You should not have to choose between an accurate chart and a readable one.
The deeper issue here is that traditional spreadsheets treat labels as static decorations rather than data-bound elements. When you move a bubble, the label should follow. When a slicer changes the view, every element should update accordingly. This is not a feature request for a future version. It is a fundamental requirement for anyone who uses charts to make decisions, not just to present them. The technology exists today to make labels as dynamic as the data they describe. AI-native tools can recalculate label placement algorithmically on every refresh, respecting overlap rules, proximity to data points, and readability constraints without asking you to lift a finger.
What this means for you is simple: stop accepting manual workarounds as the cost of doing business with live data. If your tool cannot keep labels attached to their bubbles through a refresh or a slicer change, it is not keeping up with how you actually work. Demand a solution that treats every chart element as a live, intelligent component. Your time is better spent analyzing the options market than dragging text boxes back into alignment.