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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Graph is graphing #N/A formula results as 0's, distorting the trend and look of my graph
Similar threads
- Question
