Stop Line Graph From Showing 0 When Cell is Blank

Good evening,

I have a multiple weeks of data that I am plugging into a line graph. I wish for the graph to ignore any blank cells but it continues to plot them as 0's. IFBLANK and the Hidden and Empty Cells routes will not work.

They will not work because my data comes from an average (8 points, averaged out, copied onto a new sheet, then placed into the graph). I have hidden the #DIV/0 error but, I assume, since the cell is not technically empty, Excel believes there is some data there and places it as zero.

Screenshot 2022-10-07 190522.png

Screenshot 2022-10-07 190708.png

Screenshot 2022-10-07 190747.png

Does anyone know how to work around this? I want my data to look nice (not with all the errors) and the graph to not show 0's where there is no data available. Thank you.

Change your formula to:=IFERROR(AVERAGE(C3:C10),NA()), then use conditional formatting to hide the #N/A values in table:=ISERROR([1st cell in range]).