About this chart
A calendar-style bubble chart for Excel that plots a full year — one bubble per day — with a bit of fancy styling.
Good to know: this is built as a reference file to study and customize, not a drag-and-drop template. You connect your own data and adjust it to fit — that's the point. You learn exactly how it's made.
What's included
- A year-in-bubbles calendar chart
- Image-fill styling on the data series
- A layered labeling technique you can reuse
How it works
Each bubble's X/Y position is set by the day of the month, with an image fill on the series and a labeled line chart layered behind for the month labels.
Who it's for
Anyone visualizing daily values over a year — habits, sales, weather, activity.
Excel compatibility
Designed for Microsoft Excel on Windows and Mac — Microsoft 365 or Excel 2021 recommended. Built for Excel, not Google Sheets.