Greyed out series order scroll bar

[Smudge]

Hi everyone,

I've set up a chart with 3 data series (Excel 2003) and have formatted them
to columns (2007), line(2006) and area(2005).

In the data Table the order of the series seems to be altered by the way the
data is plotted i.e. ordered - area, line, column even though the original
data are entered in the correct order on the spreadsheet.

I tried to change data series order by right clicking on a series and
choosing series order but the scroll up and down are greyed out and only one
series shows. I've tried to select all 3 sets of data to re-format but can't
do it

What am I doing wrong??
Cheers

 

[Jon Peltier]

You can change series order only among series in the same chart group. A
chart group consists of all similar series, meaning they are the same chart
type and on the same axis. By having three series with three types, you have
three separate chart groups with one series each, thus no sorting is
possible.

- Jon

 

[Smudge]

Oh well! There's me thinking I'll look clever ;-) back to plain old columns!

Thanks for your reply
Cheers