I have two bar graphs, one bar graph represents the mean plant (above soil) lengths (fall and spring) and the other represents the mean root length.
I have inverted the y-axis on the mean root length bar graph so that visually it appears like roots do, that is, going down.
I wanted to know if it is possible to create one chart (in excel) in which these two are essentially merged, i.e. the bottom of the upper bars (upper chart) touch the top of the lower bars (lower chart).
This would be for aesthetic purposes only so that the data would better represent the plants/roots.