Skip to main content

Month Sparklines

A month sparkline displays a compact calendar-style view using a 6×7 grid. Each square represents a day of the month, arranged by week (left to right) and weekday (top to bottom). This layout makes it easy to spot daily patterns over the course of a month.

Month sparklines are often used to show trends in daily activity—such as revenue, attendance, or usage—without taking up much space.

When to use month sparklines​

  • Tracking daily performance: Show how values change across the days of a specific month.
  • Identifying recurring patterns: Visualize behaviors that repeat within a month, such as weekday spikes or weekend drops.
  • Summarizing dense data: Present a full month of information in a compact format that's easy to scan and interpret.

Create a month sparkline​

  1. On the Insert tab, select Sparklines.
  2. Under Calendar Sparkline, select Insert Month Sparkline. The MonthSparkline Dialog dialog opens.
  3. Set the parameters.
  4. Click Ok. The sparkline is inserted into the selected cell.

Edit a month sparkline​

  1. Select the month sparkline in your workbook.
  2. On the Sparkline tab, select Settings. The MonthSparkline Dialog dialog opens.
  3. Adjust the parameters, then click Ok.
  4. Copy and paste the sparkline cell to duplicate the configuration in another location, as needed.

Month sparkline parameters​

The month sparkline formula supports the following formats:

=MONTHSPARKLINE(year, month, dataRange, emptyColor, startColor, middleColor, endColor)
=MONTHSPARKLINE(year, month, dataRange, colorRange)
ParameterDescription
Data RangeDefine a range where the first column contains dates and the second column contains values, such as A1:B400.
Location RangeSet the cell where the sparkline appears.
YearDefine the year in four-digit format, such as 2024.
MonthDefine the month as a number: 1 (January) to 12 (December).
Empty ColorSet the color for days with no data or a value of zero.
Start ColorSet the color for the minimum value in the month.
Middle ColorSet the color for the midpoint between the minimum and maximum values.
End ColorSet the color for the maximum value in the month.
Range ColorDefine a cell range containing color values directly.