I need to rearrange the order of data in a chart legend, please let me know if there is any way except removing the data and adding them again in order
If you click on each series in the chart, the right most entry in the
formula bar gives you the order that the series is displayed. Put a 1 in for
the first, 2 for second, etc, and the legend order should reflect your
series order.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.