Rearranging a legend

S

Shawn

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

Shaw
 
R

Robin Hammond

Shawn,

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.

Robin Hammond
www.enhanceddatasystems.com

Shawn said:
I need to rearrange the order of data in a chart legend, please let me
Click to expand...
know if there is any way except removing the data and adding them again in
order.
 
Top