I need to compare two ranges of data. The challenge is that the data is presented in range variables and I cannot figure out how to chart that data. I have attached a sample spreadsheet. I will have over 3000 rows of data in the completed sheet. The columns to be compared are D to E showing col A in the legend and using the horizontal access for the date range in col B. It is the variable data that has me stumped. I think an area chart would be the best way to display this. Any help would be appreciated.
Bookmarks