View Single Post
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Unfortunately there are some cases in which you cannot vary the order of
the legend's entries. In a combination column-line chart, for instance,
you can rearrange the column entries amongst themselves, and likewise
the line entries. But you cannot move any of the line series above the
column series. Also, if your series are split between primary and
secondary axes, those on the primary axis will be listed before those on
the secondary axis (subject to the chart type constraint above: primary
and secondary columns are still listed before primary and secondary lines).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tushar Mehta wrote:

An alternative to Barb's suggestion: double-click any series. In the
resulting dialog box, click the 'Series order' tab. Adjust the series
order in their using the various buttons.