How do I prevent a series line from going to 0 after last value?

[Guest]

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).

 

[Bernard Liengme]

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

 

[Guest]

Use a "dynamic named range", with the OFFSET command. Many help/instructions
on this can be googled (and found on this forum elsewhere). One that jumps to
my mind is http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
HTH,
GL
Henk