Smart Way of Plotting Daily Data by Each Month

New Contributor

I've got 4 years worth of daily data and I need a smart way of plotting it by month. So e.g 31 days line graph for Jan then 28 for Feb. etc. What's the easy way instead of traversing through it all adding plots manually? 

1 Reply


I suggest using a FILTER function (with two selection criteria, for start and end dates); the references to the data can be accomplished with the INDIRECT function.  See below and the attached workbook.


2023-02-08 SM 1.jpg

Change the date values in cells C2 and C3 for the chart to be redrawn (or if you want to get fancier, you could easily put a formula into C2 that would calculate the first day of the month from the value in C3).


Edit: By default, the Y-axis range of values is determined dynamically from the chart data.  So to maintain consistency between your ~48 graphs, you may want to assign a fixed range of values.