It sounds like you could use the Pivot Table chart (Under Chart Types > Tables and Textboxes > Pivot Table) with the Account Numbers being your rows, Dates being your columns and Sales being the value.
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**