Hi,

I have a chart that visually displays two sets of data. Excel automatically displays the legend with the right little colored squares and corresponding data set names. The problem is that the order in which the two legends appear is "reversed". That is to say that, instead of displaying the name, and the little colored square, of the first data set on the left side of the legend, it displays it on the right side of the legend. The exact opposite occurs with the second data set. I've tried right clicking the chart and clicking the data series format option of the pop up menu, alternating the series order using the up and down arrow keys but that also changes the order in which the data sets are graphiclly displayed. Since I'm using a xlColumnStacked chart, this option reverses the order of the bottom and top of the stacked bars and that doesn't work for me. I just want to change the order in which the legends appear without changing the graph itself.

Thanks for any help!