Hey João,

Thank you for the tip. Prior to added the FormatDateTime(Sheet1.DateTime, "MM-yyyy") my result was the screen shot below even thought I sorted the table with the date in ascending order. After inserting the line above, the line just uses two of the dates versus all the dates in the list. trying to figure out how to adjust the order of the x-axis line so that the amount line can just go up and down, if that makes sense. It's splitting into two line 

Thank you for your help!

that's an interesting chart Ashley, I wouldn't know how to make that if I wanted to. Can you share the oml, or maybe the details (from debug) of each data point ?

EDIT : turns out I can if i try hard enough :-) You'll have to revisit how sure you are about reading them on ascending datetime, because that looks like the reason after all.  See attached oml, they are not in ascending datetime, and I get the same chart.

Hahahaha! Thanks for taking a crack at it, I'll look into fixing the order. Thanks Dorine!

I clicked on the aggregate, then sorting, then add sorting, selected the date/time attribute and then ascending as the sorting setting and that fixed it. Just wanted to add in the exact solution for this instance :) Thanks to everyone for the help!