I have a stacked line chart that is plotting month-over-month data for the purposes of visualizing how this month’s data stacks up against the same month last year and the year prior. Because the remaining months this year have no value, the graph is plotting a straight line for the blank months (in cumulative view) and a dip to zero (in non-cumulative view).
Is there a way for me to remove the graph points for months that have no data? I want my line to end at January (the month where the last current-year data is added to the table). I checked and unchecked the “show empty values” box, and that did nothing. See February - June.