Enable easy showing/hiding of data series in a chart in Excel 365 for Mac
In Excel for Windows you can select a check box in the Select Data menu which toggles whether a data series is displayed on a chart or not. It would be useful to include this feature for Mac as well (over and above of simple filtering or hiding/unhiding of data cells.)
It would be nice to easily add radio buttons or something similar on the chart itself to enable/disable each series.
I support this feature request.
It is a very useful feature. Also we need compatibility between versions - when opening files created in Windows it is difficult to display the data that has been hidden on the windows PC.
Anyone know how to do this?