Forum Discussion
viu_MD
Nov 07, 2022Copper Contributor
How to omit variable blank series categories in excel chart legend
Hi By no means an Excel expert but can through together a chart easily enough (or so I thought). Whilst my chart remains static, the data that populates it will change. Accordingly I have set my ...
Martin_Weiss
Nov 08, 2022Bronze Contributor
Hi viu_MD
I tried to put a little example together. If I understood you correctly, you have a certain series label, but not values for it, like in this screenshot:
If that's the case, the only option I know is to hide the respective column. By default, hidden data is not shown in the chart, so there will also be no legend:
The behaviour of hidden data can be changed in the "Select Data Source"-dialogue:
But of course, you have to hide/unhide the columns manually, when appropriate.
Maybe this helps.