Charlotte Robinson on 22 Jan 2021 12:25:52
Can we have the ability to hide series from a chart but still display the data labels? As an example I have a stacked column chart which shows the number of successful bids and the number of unsuccessful bids (values) by year (axis). I'd like to include the success rate (as a data label) for each year but not plot it as a series on the chart (I can do a work around with a second axis, making the series white and changing the start/end of the axis but it would be neater and easier if we were able to simply hide the series).