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

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" wrote in
message ...

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