I've created a scatter chart and have data in the source data cells with a formula only. Those formulas are graphing on the chart as a "0" value.
Is there any way that I can have a formula in a cell and NOT have it show up on the chart as zero, basically not show up on the chart at all? I only want the data to show on the chart once the number value is calculated. Simple formula I have is as follows:
=IF(Data!G9="","",Data!G9)
Any help would be appreciated.
Is there any way that I can have a formula in a cell and NOT have it show up on the chart as zero, basically not show up on the chart at all? I only want the data to show on the chart once the number value is calculated. Simple formula I have is as follows:
=IF(Data!G9="","",Data!G9)
Any help would be appreciated.
