charting calculated values

[dpj]

I am charting calculated values for each month Jan to Dec. The lin
shows values for each completed month but then goes to zero for month
where values have not yet been entered. How can the chart show only th
values greater than zero

 

[Myrna Larson]

Are the cells empty for future months? Under Tools/Options/Chart there are
several options as to how to handle empty cells.

 

[Debra Dalgleish]

Jon Peltier has information on creating dynamic charts:

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