Series order in a chart legend.

I want to reorder the series in a chart. The posting talk about editing a
command line. But I do not see a command line and Excel help does not know
what a command line is. When I double clik on the series (as suggested in the
postings), the menu does not offer a tab for reordering the entries. It only
offer changing the text size or patterns in the legend. So why is this so
difficult to accomplish?

What type of graph are you plotting?

Select the axis of the data that you want to change- by clicking on the axis (two
squares should appear on either side of the axis)- Not the data series... either double click or right click and select 'Format Axis'. This brings up a pop-up form, go to the scale tab. On the bottom of the form there are three check boxes, select the middle box- categories in reverse order. That should work-
if not please let me know-
If you'd like to use code to do it- see below, the line in blue is the relevant one in the with block.
cheers,
pim

ActiveSheet.ChartObjects(1).Activate
With ActiveChart.Axes(xlCategory)
.CrossesAt = 1
.TickLabelSpacing = 1
.TickMarkSpacing = 1
.AxisBetweenCategories = True
.ReversePlotOrder = True
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow
End With

It sounds like maybe you are double clicking the series in the legend. You
want to double click the series (the bar/column/data point) in the plot area
instead. From there there should be a tab called "Series Order" where you can
move them up and down.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"Phil" wrote:

> I want to reorder the series in a chart. The posting talk about editing a
> command line. But I do not see a command line and Excel help does not know
> what a command line is. When I double clik on the series (as suggested in the
> postings), the menu does not offer a tab for reordering the entries. It only
> offer changing the text size or patterns in the legend. So why is this so
> difficult to accomplish?

Note that Excel only allows you to reorder similar series. For example, if you have
two column series and two line series in the chart, you can only reorder the line
series amongst themselves, and likewise the column series. You cannot move the line
series legend entries before the column series entries. Similarly, within a group,
the secondary axis series are always listed after the primary axis series.

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

Christopher Scott [MSFT] wrote:

> It sounds like maybe you are double clicking the series in the legend. You
> want to double click the series (the bar/column/data point) in the plot area
> instead. From there there should be a tab called "Series Order" where you can
> move them up and down.