I have been searching, but can't seem to come up with what I need. It seems there must be a way since they say a picture is more descriptive... this is my representative data:sample.jpg
I would like to merge these two charts so that all 6 lines are on the same chart and the X axis titles are Jan, Feb...
I would like to do it without rearranging the data (altho adding additional rows is ok) because I also want a 13month graph as well (i.e. the most current 13 months) I have read about dynamic ranges and I want to do that in the future, (but I am still manually changing the range) Before I tackle that, I want to first figure out how to get year to year in the same chart.
Here is the actual sheet
Bookmarks