Thread: XL03 - Days to Months

Hi,

I've got a chart that updates each day with various new values. It's pulling this data from a website, so each new day, means a new row of data.

I want to make a chart that displays this information, but in a month by month form...

How can I make it recognize all the data from the individual days as being in the same month, and add the info together without having to do it manually each day?

Does this make sense?

Thanks,
JN

The chart will not summarize the data. You will have to do that with formula or code.

If you need more help post an example workbook, including chart.