I have an excel spreadsheet of income and expenditures. The columns are as follows:
Date Description Expense Income Ruing
The first two column headers are self-explanatory. The Ruing column is the ruing total and is set as:
Ruing[i] = Ruing[i - 1] + Income[i] - Expense[i]
I currently have a chart that graphs the Date column on the X-axis and Ruing 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.
برچسب:
نویسنده: استخدام کار