Hello everyone,

I have a list of data, that goes from january to december. (every week day,
where there was stock market activity) I am trying to make a chart to track
price changes, day-to-day, the chart looks fine, from january to today, but
after today, the chart plummets to 0 and makes the chart very difficult to
read. Is there a way to have the chart only show dates with data other than
0 or "#DIV/0"? and then once these columns get filled, the chart updates and
adds these dates? Is what I'm asking possible?

Thank you all kindly,
Confused Man