Excel graph plotting for large data set with dates

Excel graph plotting for large data set with dates

I have a large table of data (not created by me) with more than 1500 rows. The first column of which is a list of dates, monthly, starting from 1870. Some of the columns contain data for the full rage of dates while in others data is available only in more recent times. I want to experiment plotting all sorts of combinations of columns and date ranges. I have two issues hampering me.