ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bring series to front (https://www.excelbanter.com/charts-charting-excel/78705-bring-series-front.html)

coa01gsb

Bring series to front
 

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


Jon Peltier

Bring series to front
 
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





All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com