Three options:
1) replace the zeros (or empty cells) by =NA()
2) select chart: use Tools | Options and on Chart tab specify how missing
values are to be treated
3) make a dynamic chart; see http://processtrends.com/pg_dynamic_charts.htm
best wishes

V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jim S" <Jim wrote in message
...
I have a series of monthly data with values for Jan - Jun, but blank values
for Jul - Dec. It's a 100% stacked column chart with the series lines
added
in. Currently, the series lines all drop to 0 in July. I need them to
end
at Jun (or last month with non-blank data), but can't find any option to
fix
(I already have the default set to hide or not display missing values).