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
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" <coa01gsb.2516d0_1142963106.2596@excelforum-nospam.com> wrote in
message news:coa01gsb.2516d0_1142963106.2596@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks