"real time charts"?

[confused man]

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

 

[Don Guillett]

try going to chart options>axes>change to category

 

[confused man]

Thanks, but that did not change anything in terms of the scaling of the
chart... all the "0" values were still present at the end of the chart. Any
other thoughts?

thanks,
Confused Man

 

[Debra Dalgleish]

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html