Trendline Help

[nhbartos]

Hi folks,

I have a graph that charts percentages by month, Jan - Dec and have a trendline.

Now, I am only several months into my year, so I have data in Jan, feb, mar, and apr, and zeros for the remaining months.
The formula used for this percentage delivers a zero for the months where data has not yet been entered. So, after April, the trendline drops to zero. Normal, I think. But, I want it to ignore the zeros, and only continue as data is entered for the remaining months. I also want to keep the all the months on the graph.

Possible?

I have excel 2016, and it has a custom trendline option, but cannot find any info on how to use it.
Should this be resolved in the percentage formula?

I am simply using =B2/A2 to get the percentage for two data points in about 100 rows of data.

 

[mole999]

if you model your zeros as N/A they shouldn't map in charts

 

[nhbartos]

The cells are calculating a percentage, and I have this in there now: =IF(OR(ISBLANK(R7),ISBLANK(S7)), "", R7-S7)
So, I have it bringing back a blank, but I have the same issue.

Is there a way to modify the formula above to still calculate the percentage, but show an N/A when there are now values to calculate?

 

[nhbartos]

Figured it out, thanks.