Is there a way to hide the zero points of a series?
I have 2 series on the chart being populated from a single data object (which can be changed). It is showing current "production" and forcasted. Obviously current production ends "today" and I need to hide the rest of the points. I have attached a screenshot of the current chart, everything on the red spline past the red arrow should not be displayed.
Also in the screenshot, the data label runs out of the chart area, is there a way to fix this?
Thanks for any help in advance.
I have 2 series on the chart being populated from a single data object (which can be changed). It is showing current "production" and forcasted. Obviously current production ends "today" and I need to hide the rest of the points. I have attached a screenshot of the current chart, everything on the red spline past the red arrow should not be displayed.
Also in the screenshot, the data label runs out of the chart area, is there a way to fix this?
Thanks for any help in advance.