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