Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some data across several months, August to November. Some months the percentage is 0. I want my charts at this moment to show August through December. When I un-check surpress Zero-Values January shows back up on my X-Axis even though it is not highlighted. Is there a way to show 0 values on a graph without showing months that are not highlighted? This is also a problem as my graph is a drill down chart so if I click on September I will see data for September but the weeks of other months will show up on the x-axis.
Hi Michael,
One work around is you can give the white color for line where value is zero.
Try selecting "Continuous" on the Axes tab. It is about half way down on the left.