Line graph - stop the drop to zero...

**PaddlepopLion** · 02-01-2024, 06:50 PM

Hi all,

a simple question for the experts out there. The attached file shows cycle-count data in a warehouse that I am plotting on a simple line-graph. I want to see it without the drop to zero from cells that remain unpopulated.

I have watched a couple of YT vids and Google'd the problem but can't seem to find the key to unlock the problem.
Any and all help is appreciated in advance.

Regards
PPL

**MrShorty** · 02-01-2024, 07:21 PM

Are you required to return the "#n/a" text string in column J of IRA_2024? Excel charts treat text strings and most other error values as the number 0. However, if you can use the #N/A error value (NA() function) in place of "#n/a" in that IFERROR() function, Excel charts will treat the N/A error value similar to a blank cell. =IFERROR(1-(F2/E2),NA())