Hi there

I'm trying to create a football score graph that shows 4 quarters of football on the x axis (i.s q1 q2 q3 q4)

my issue is that when i used a stacked or normal line, the quarters that don't yet have a score (0) still graph so my worm/line will go up then down

I want the graph to show all four sections (quarters) of football, but not to graph the zeros (i.e a progressive score worm like the picture and starting at 0 and cumulative score) as I will be updating the fours cells that contain the score as I go (for a work function)

worm.jpg

any help would be ace!!

thanks