Hello again,

I'm trying to do a similar thing with daily data instead of hourly data. I have a daily time series lasting one year (1/1/2007 to 12/31/2007), with numerical values for each day in columns. I want to be able to select a month and display the daily data for that month in a chart (i.e. 28, 30, or 31 values, depending on the month).

I tried modifying the hourly spreadsheet you sent me, but I'm not sure how to change the index and match formulas. I tried looking online but it's a bit tricky for a beginner like myself.

Also - I want to display the month and year as the chart title.

Could you please take a look at the sheet I've attached and tell me where I'm going wrong?

Thanks so much!Daily Template.xlsx