Chart using alphabetical sorting for integer field

Hey all,

I've got charts that utilize a data link set up that are based on time. When the chart is set up to use a date field as the horizontal axis it works great, however it needs to be based on number of days instead of the date since they start on different days. We created a new integer field to solve the issue but when I use that field instead of the date field it messes with the order. Instead of it showing properly, 128, 129, 130, 131, etc. it shows as 128, 129, 13, 130, etc. Does anyone have any idea on how to get around this? We've got it to order them correctly by padding the field with zeros but it looks bad and clutters up the horizontal axis.

Any ideas would help!

Thanks in advance!