From a chart's series to x/y values range with a right click menu option
Consider adding these options to a selected series' or datapoint context menu:
. Go to the X values range
. Go to the Y values range
. Go to the series name range
. Extend/contract series range by n cells.
I've actually implemented all of this for my own use in VBA, with keyboard shortcuts. So Alt+Right extends every range one cell, Alt+Shift+Right extends every range 20 cells, Ctrl+i in a chart takes me to the X values range (or cell, if a single data point is selected). HUGE time saver.
These are interesting ideas. Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.