Hi,

I have a dataset containing 2 columns. The first is an hourly time series in the form m/dd/yyyy h:mm, which is one year long (1/1/2011 0:00 to 12/31/2011 23:00). The second column contains a numeric value for each hour. I want to create one graph (xy scatter with smoothed lines) for each day of the year - so each graph would have 24 values, one for each hour of the day. My question is - is there an efficient way to do this (perhaps using a macro or some other shortcut)? Or do I need to create all 365 graphs manually?

Thanks very much for your help,
Caitlin