I have a google sheet tracking $ for different categories (savings, regular expenses, daily expenses). I like to keep track of individual dates and transactions.
As you can see, only Daily is showing correctly as I have plotted Column H as the x-axis. This causes Savings and Regular to plot incorrectly as sheets is taking C4 and C5 as 'January' transactions, E4 is showing under 'January' instead of starting in April, etc.
Is there any way I can plot all 3 categories against 1 x-axis (month)? My actual sheet has data up to 100 rows (in each category) and I wish to avoid collating the data such that my sheet requires endless scrolling.