I have a google sheet tracking $ for different categories (savings, regular expenses, daily expenses). I like to keep track of individual dates and transactions.

enter image description here

enter image description here

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.

enter image description here

  • pls share a copy of your sheet – user0 Apr 28 '19 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.