how do i create a "bihistorgram" graph using excel?

[Guest]

I would like to create a "bihistogram" graph. A good example of the type of
plot is located at the following link:
http://www.itl.nist.gov/div898/handbook/eda/section3/bihistog.htm

Thanks, Dave

 

[Andy Pope]

Hi,

One way would be to use stacked column chart.
With your data arrange in 3 columns.

Batch 1 Batch 2
100 0 0
200 0 0
300 2 -2
400 4 -4
500 6 -6
600 8 -8
700 6 -6
800 4 -4
900 2 -2
1000 1 -1
1100 0 0

If your Batch 2 figures are actual positive then you could use a
clustered column chart and plot Batch 2 on the secondary axis.
Adjust both y axis to have the same Min and Max. For the above data
example use -10 and +10.
The double click the secondary y axis and plot values in reverse order.
You can then format the secondary y axis so the values are not displayed.

For both methods format a data series and on the Options tab set the gap
width to zero to remove the space between bars.

Cheers
Andy