I have an excel spreadsheet containing 53 weeks worth financial data. Dates & Currency.

When I map that to a line chart it displays only 6 weeks worth of data. If I change the X axis Range to display all data (putting in the date range) it shows the months but the data disappears.

The data spans from October to September but the Chart will only show data from the first week of January to the 2nd week of February.

It's Linear data starting at $0 and ending at $285,000

It's a simple line chart, I would think it would be fairly simple to build but its rather difficult. I can build the same thing in excel in seconds. I've been banging my head against the wall getting this to work correctly for hours. I'm ready to give up and go back to excel services charts.