I've an excel spreadsheet with 2800+ rows of data in the form: date, $amount. The rows are from dates 1/1/2004 through 2/26/2017. Not every date is listed, but most are.
I'd like to produce a graph that shows the values at month intervals. Sure I could manipulate the data set to do that, but I know there's and easier way to get this displayed on a simple Line Chart.