I have a table of numbers with totals and am currently trying to graph them with a trendline. The table is for totals at the end of each month plus the last 2 months of the prior year. My trendline picks up the zero values that are currently being summed for the months that have yet to be completed for the year. I've used the NA() function and this gets the trendline to behave correctly, but is there any way to not have #N/A displayed in the cell of the table? I would much prefer a blank or zero to appear. Thanks in advance!
-
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.
