Horizontal axis not linear

I have an excel spreadsheet of income and expenditures. The columns are as follows:

Date Description Expense Income Running

The first two column headers are self-explanatory. The Running column is the running total and is set as:

Running[i] = Running[i - 1] + Income[i] - Expense[i]

I currently have a chart that graphs the Date column on the X-axis and Running column on the Y-axis. However, if there is a week that has more expenditures than normal, then there appears to be a bigger gap between the monthly income jump up (same date every month) than a month with fewer expenses, where the monthly jump up is closer together.

DESIRE: I would like the X-axis to be linear, such that no matter how man expenses there are in a given month, the distance from each monthly income jump is the same.

Recent Questions...