I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always
fixed/locked. The issue I'm facing is that when a value for a certain month is 0, I want it to skip to the last non-zero month . Meaning the ranges selected forming the chart should exclude the month with the value zero. Which in most cases is the top month.
The image below should clear it up.
Is there a way to have the chart range be dynamic based on certain values?