Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlap printing | Excel Discussion (Misc queries) | |||
DataLabel Overlap | Charts and Charting in Excel | |||
Change overlap of 2 columns on 2 axes | Charts and Charting in Excel | |||
Show Overlap | Charts and Charting in Excel | |||
auditing arrow overlap | Excel Discussion (Misc queries) |