Once you have gotten the tick data into Excel and performed the calculations for the distribution, you will need to create two charts one to display the price and an adjoining chart to display the volume distribution.
For further details see the Willow Talk titled Volume Charts.