Stacked Chart - One series not stacking

[Excelint]

Hello,

I have a combination stack columns with line chart. The stacked columns being hours worked and the line being hours available to work. The data sets being stacked are hours worked per discipline. The problem is one data sat is not stacking on top of the other data sets. It's gone rogue and does it's own thing by starting at zero. How can I get it to stack on top of the other columns. Right now it is sitting in front of the stacked columns overlapping them. I've randomly had this problem before with this chart. I've tried changing all the data series to another chart type and then back just to reset it. This provides mixed results so I don't know what to do.

Any help would greatly be appreciated!

Thanks!

 

[RoryA]

It sounds like that series is plotting on a different axis - probably the secondary. Right click it, choose Format Series and then make sure it's on the same axis as the other columns.

 

[Excelint]

It is using the primary axis like the other columns.

 

[RoryA]

I'd need to see the fie then because what I think you are describing should be impossible.

 

[Excelint]

I'll see if I can find a way to send it. May be confidential info.

I appreciate the help.