Step 4: Convert the stacked column chart to the box plot style. Hide the bottom data series. Create whiskers for the box plot. Color the middle areas. Step 1: Calculate the quartile values. First you need to calculate the minimum, maximum and median values, as .