May 20 2022 01:10 AM
Hi. I've created this chart in Excel and want to make the entries in the legend appear in the same order top to bottom as they are in the chart (the legend reads A to D from the top but the bars read A to D from the bottom). I tried the following:
However, while this reverses the order of the legend entries it also reverses the order in which they appear in the chart, leading to the exact same issue remaining as per this:
Anyone know how to resolve this problem? It would even be helpful to be told that Excel can't do this at all (the problem doesn't seem to occur with horizontal bar charts). Many thanks. Alan
May 20 2022 01:54 AM
What happens if you create the chart again from scratch? When I tried to reproduce your problem, the legend was in the correct order by default.
May 20 2022 02:32 AM
@Hans Vogelaar I actually DID create it from scratch just before creating the post. It was actually one at my workplace that I was working on and having this problem with so I created the new chart on my home laptop but it seemed to have the same problem.
May 20 2022 02:37 AM
I'm afraid I can't explain that. Sorry!