Graph is graphing #N/A formula results as 0's, distorting the trend and look of my graph

[jworkman7]

It's weird. In one tab of my workbook, any formulas resulting in 0's I have programmed to actually return a #N/A, so that when graphed, the graph looks cleaner, and the trendline is true. But in another new tab I'm working in, the #N/A results show up as zeroes on the graphs. Any reason you know of which might be causing this? It's affecting the scaling of some graphs, where the values are in the thousands, so with the zeros present, the trend looks flat due to scale.