Help with stacked bar chart

[rakso]

Hello!

Ive encountered a problem i have no idea how to solve. Ill write whole story:

We had a practical assignment with water pumps. We took the power consumed by pumps like 240W for example and measured the height of hose 1-7 meters. So the power consumption changes when the hose gets higher. I figured that this would be nicely expressed in a stacked bar chart, one bar for height the another for power. But since the value gap is so big i had to move one of the data to secondary Y axis. When i did that the bars that are higher overlapped the smaller ones and i cant see them. They are all behind the large ones. and the chart is useless. Scatter shows what i want to show but those 2 noodles on my chart look gross.
Does someone know how could I set up my stacked bar chart so that lower values would be seen in front of bigger ones?

Thankyou1

 

[bobsan42]

try to position them next to one another.
The way to do it is maybe to insert two other series of empty data - (one as second for the primary axis, the other first for the secondary axis). Then adjust the distances between them so that the two real bars do not overlap.