Hello there,

I have a spreadsheet plotting various line graphs. I would prefer them not to plot any zero values because if I don't fill in data for all worksheets the graph will fall right back down to zero like a cliff edge.

I've done a bit of homework already and I understand I need to use NA() and if statements so that the graph won't render the zero values. I just don't know which formula to add it to- or maybe I'm completely off the mark

Any help would be really appreciated, many thanks!

WorkoutTracker.xlsx