Hello everyone. I have a somewhat basic spreadsheet that keeps track of my income and expenses. I was trying to create a stacked column chart that displays my monthly income and monthly expenses. I have my income on one sheet and expenses on another. Each row on both sheets contain data for a particular day an income or expense was made. I am trying to have the chart sum all of January's income and display it as one column or line graph depending on what chart type I think works best. So for example January might have 10 rows of income with the dollar amount in cells D1:D10 while February has 20 rows of income with the dollar amount in cells D11:D20. And same scenario for the Expenses sheet. January and February will have different amount of rows recording for each month. Is there a way to highlight column D (amounts column) and have the chart create a column that displays the sum for each month for both the Income sheet and Expense sheet?
I hope I am explaining my challenge correctly.
Regards,
BP
Bookmarks