Comparison Histogram

Comparison Histogram :

Steps on Excel : Below is an Example.

Convert Family B data into negative. And select A1:C6.

From insert tab, select bar graph (Clustered Bar) :

By selecting the Clustered Bar Graph, below is the print shot how it comes:

From Format data Series Dialog Box, and in series option bring it to 100% overlapped.

Format Major Gridlines with 'No line'.

From Format Axis dialogue box, select Major tick type as none and Axis labels as Low:

From Format Axis dialog box, and in number option select Custom and enter 0;0;0 click Add and then close. It is useful to bring the axis as positive values :

Legends deleted and from text box we text Family A and Family B to better presentation.

Thank you !