I have monthly data across several years. I want to chart SOME of the months.
The monthly data are in two different excel files. Can I create a chart using
some source data from one file and other source data from a second file?

IF the answer is that I have to use a pivot chart/table, I have tried that
and the pivot chart/table seems to ONLY plot aggregate data; that is, I
cannot figure out how a pivot table/chart can plot each month's data
separately.

THanks for any help.