Chart Legend - Order of Entries

I'm running Excel2002 and have created a chart using several series of XY
Scatter data. The chart is working fine, but I do not like the order in
which the various groups of source data are listed within the Chart Legend.
They don't appear to be listed either alphabetical or sequenced in relation
to the time they were created. I cannot find a control that lets me move up
or down the item listings within the legend. Is that possible? Thanks for
your help.

Hi,

You can specify the order by double clicking one of the data series and
on the Series order tab change the plot order.

Cheers
Andy

Ron wrote:
> I'm running Excel2002 and have created a chart using several series of XY
> Scatter data. The chart is working fine, but I do not like the order in
> which the various groups of source data are listed within the Chart Legend.
> They don't appear to be listed either alphabetical or sequenced in relation
> to the time they were created. I cannot find a control that lets me move up
> or down the item listings within the legend. Is that possible? Thanks for
> your help.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks, Andy. I found the series order tab, and that worked well. But... I
also have a few trendlines associated with some of the data series. The
trendlines were not present on the series order tab. Is there any way to
also rearrange their order within the Chart Legend?

"Andy Pope" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> You can specify the order by double clicking one of the data series and on
> the Series order tab change the plot order.
>
> Cheers
> Andy
>
> Ron wrote:
>> I'm running Excel2002 and have created a chart using several series of XY
>> Scatter data. The chart is working fine, but I do not like the order in
>> which the various groups of source data are listed within the Chart
>> Legend. They don't appear to be listed either alphabetical or sequenced
>> in relation to the time they were created. I cannot find a control that
>> lets me move up or down the item listings within the legend. Is that
>> possible? Thanks for your help.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

Hi,

There doesn't appear to be any way to position trendlines.
Your best solution maybe to create your own legend. You could use
autoshapes and textboxes. Or you may be able to use data labels with the
legend showing, this may require you to add dummy data series, it
depends how complex your chart is.

Cheers
Andy

Ron wrote:
> Thanks, Andy. I found the series order tab, and that worked well. But... I
> also have a few trendlines associated with some of the data series. The
> trendlines were not present on the series order tab. Is there any way to
> also rearrange their order within the Chart Legend?
>
> "Andy Pope" <[email protected]> wrote in message
> news:%[email protected]...
>
>>Hi,
>>
>>You can specify the order by double clicking one of the data series and on
>>the Series order tab change the plot order.
>>
>>Cheers
>>Andy
>>
>>Ron wrote:
>>
>>>I'm running Excel2002 and have created a chart using several series of XY
>>>Scatter data. The chart is working fine, but I do not like the order in
>>>which the various groups of source data are listed within the Chart
>>>Legend. They don't appear to be listed either alphabetical or sequenced
>>>in relation to the time they were created. I cannot find a control that
>>>lets me move up or down the item listings within the legend. Is that
>>>possible? Thanks for your help.
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy - Thanks again for the prompt feedback. I thought it was worth a shot.
I don't believe I need order in my life that bad. <G> Thanks again.

"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> There doesn't appear to be any way to position trendlines.
> Your best solution maybe to create your own legend. You could use
> autoshapes and textboxes. Or you may be able to use data labels with the
> legend showing, this may require you to add dummy data series, it depends
> how complex your chart is.
>
> Cheers
> Andy
>
> Ron wrote:
>> Thanks, Andy. I found the series order tab, and that worked well. But...
>> I also have a few trendlines associated with some of the data series. The
>> trendlines were not present on the series order tab. Is there any way to
>> also rearrange their order within the Chart Legend?
>>
>> "Andy Pope" <[email protected]> wrote in message
>> news:%[email protected]...
>>
>>>Hi,
>>>
>>>You can specify the order by double clicking one of the data series and
>>>on the Series order tab change the plot order.
>>>
>>>Cheers
>>>Andy
>>>
>>>Ron wrote:
>>>
>>>>I'm running Excel2002 and have created a chart using several series of
>>>>XY Scatter data. The chart is working fine, but I do not like the order
>>>>in which the various groups of source data are listed within the Chart
>>>>Legend. They don't appear to be listed either alphabetical or sequenced
>>>>in relation to the time they were created. I cannot find a control that
>>>>lets me move up or down the item listings within the legend. Is that
>>>>possible? Thanks for your help.
>>>
>>>--
>>>
>>>Andy Pope, Microsoft MVP - Excel
>>>http://www.andypope.info
>>
>>
>>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info