Is it possible to remove null values from a line chart with multiple lines on the same axis.
For example I have a line chart with the month as the dimension (x) and dollar amount for measure (y). I have planned dollars for the entire FY but data through January for actuals. When I plot this, it shows "0" for those months that are empty. I've check/unchecked null and confirmed that the csv does not have a number entry.
Is there an esay way to do this? seems rather foundational to not graph zero entries when moving through a FY for tracking budgets, savings, etc.