Bring series to front

[coa01gsb]

Hi All,

I have a graph with several series on it, I am after a way of being able to easily bring a series of my choice to the front of the graph.

Ideally I would be able to click on a series listed in the Key and that would bring the series in question to the front.

Is this possible?

If so, how?

All help will be much appreciated

Kind regards

[Jon Peltier]

The easiest way is to double click on a series (any series), and use the
Series Order tab (or is it just the Order tab?) to move the intended series
higher lower in the list.

If it's a combination chart or a primary-secondary axis chart, you may not
have full control over the series order.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"coa01gsb" <[email protected]> wrote in
message news:[email protected]...
>
> Hi All,
>
> I have a graph with several series on it, I am after a way of being
> able to easily bring a series of my choice to the front of the graph.
>
> Ideally I would be able to click on a series listed in the Key and that
> would bring the series in question to the front.
>
> Is this possible?
>
> If so, how?
>
> All help will be much appreciated
>
> Kind regards
>
>
> --
> coa01gsb
> ------------------------------------------------------------------------
> coa01gsb's Profile:
> http://www.excelforum.com/member.php...o&userid=31214
> View this thread: http://www.excelforum.com/showthread...hreadid=524878
>