Looking to have a stacked collum chart showing difference in values



I am looking to have a stacked column chart showing the change in two values over the course of past, present, and future dates. I'd like this graph to update with new dates automatically based on what is added in the tracker.

The stacked column chart should display the months of a year in the x axis and thee quantity of what I'm measuring in the Y axis.

Is this possible to automate and do with one or a small amount of functions? I'd prefer not to create a sheet summary function for every month.

Please let me know if there are any questions.


  • L_123
    L_123 ✭✭✭✭✭✭

    you can do this by adding 2 columns to your sheet,

    The first column "Month" would be 1-12 as integers

    the second column would be a =sumifs(columntoadd:columntoadd,date:date,month@row)