change overlap priotity
 

I have 2 bar series of which I want the 1st series to overlap the 2nd (on top).
When I choose the formatting series tab, it look likes the 2nd series always
comes on top of the 1st.
How can I adjust this in reverse way, meaning 1st on top of 2nd.
By the way, I can't swich series because a lot of bars are colored separately

change overlap priotity
 

You have to switch series. But you don't need to worry about the separately
formatted bars. Change the order by changing the last number in the series
formula.

Click on the series in front. In the formula bar you will see

=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$6,Sheet1!$B$4:$ B$6,2)

Change the 2 to a 1:

=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$6,Sheet1!$B$4:$ B$6,1)

Now this series will move to the back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Roland" wrote in message
...
I have 2 bar series of which I want the 1st series to overlap the 2nd (on
top).
When I choose the formatting series tab, it look likes the 2nd series
always
comes on top of the 1st.
How can I adjust this in reverse way, meaning 1st on top of 2nd.
By the way, I can't swich series because a lot of bars are colored
separately

change overlap priotity
 

Agree
but both series also switch places because of order what I don't want
the original (colored) series 1 should stay 1st, and the 2nd (not colored)
should be in 2nd order but behind series 1


"Jon Peltier" wrote:

You have to switch series. But you don't need to worry about the separately
formatted bars. Change the order by changing the last number in the series
formula.

Click on the series in front. In the formula bar you will see

=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$6,Sheet1!$B$4:$ B$6,2)

Change the 2 to a 1:

=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$6,Sheet1!$B$4:$ B$6,1)

Now this series will move to the back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Roland" wrote in message
...
I have 2 bar series of which I want the 1st series to overlap the 2nd (on
top).
When I choose the formatting series tab, it look likes the 2nd series
always
comes on top of the 1st.
How can I adjust this in reverse way, meaning 1st on top of 2nd.
By the way, I can't swich series because a lot of bars are colored
separately