I have a google sheet tracking $ for different categories (savings, regular expenses, daily expenses). I like to follow dates and individual transactions.
As you can see, only Daily appears correctly, because I have drawn column H as x axis. This causes a saving and normal graph plot error, as the sheets consider C4 and C5 as "January" transactions, E4 appears as "January" instead of starting in April, and so on.
Is it possible to draw the 3 categories against 1 x axis (months)? My sheet contains data up to 100 lines (in each category) and I want to avoid grouping them together, so my sheet requires endless scrolling.