Overview
The vertical companion to the Horizontal RainCloud Chart. This workbook creates vertically-oriented RainCloud charts with the density cloud on the left, box plot in the centre, and scatter points (rain drops) on the right. Built with 27 embedded chart objects and VBA macros.
Download the Excel file (.xlsm)
Sheets Included
- Vertical Raincloud - 1 Cloud: Single distribution with density curve, stacked column box plot (25th, 25–50th, 50–75th percentiles), error bar whiskers, and jittered scatter points.
- Vertical Raincloud - 3 Clouds: Three distributions compared side-by-side, each with its own cloud, box plot, and rain drops. Includes sorted data, distribution calculations, and X-position offsets for each cloud.
Chart Architecture
- Cloud Layer: Density distribution rendered as an area chart, positioned with X-offset formulas to sit alongside the box plot.
- Box Plot Layer: Stacked column chart with percentile breakpoints and error bars for min/max whiskers.
- Scatter Layer: Individual data points with positive/negative jitter to avoid overplotting.
- Percentile Calculations: Location and length values for each quartile segment, driving the stacked column dimensions.
When to Use This
Use the vertical orientation when your data labels are horizontal text (e.g., group names along the X-axis) or when the vertical layout fits better in your report or dashboard. The 3-cloud version is perfect for comparing distributions across groups — survey responses by region, performance metrics by team, or financial returns by fund.