Option to remove zeros from Scatter Charts
Options
breso
✭✭✭
When using a scatter chart any value of 0 is plotted on the axis. It would be great to have an option to toggle off displaying these values. It crowds the scatter plot with junk information. Here is a before and after example where I use a formula on the metrics sheet to change any zero values to null values.
With 0 Values Plotted:
Without 0 Values Plotted:
Tags:
Comments
-
Can I ask what the formula was that you used?
-
It would be great to see the formula you used. I also was able to get my cell values to be Null but it still charted as zero on the scatter graph. We really need the ability to eliminate this useless data.
