I would like to have a pie chart that selects data points from a static range
only if they are non-blank cells. searching on the internet i found the code
that i am useing now which gets me a pie chart with only the datapoints i
want, but the legend still shows all possible points even if they are blank.
i have defined two names as ranges:

statevalues =OFFSET(statechtdata!$A$2,0,0,COUNTA(statechtdata! $A:$A)-1,1)

statevaluesY =OFFSET(statevalues,0,1)

and the chart series is as follows:

=SERIES(statechtdata!$A$1,'sample portfolio.xls'!statevalues,'sample
portfolio.xls'!statevaluesY,1)

also, the pie chart originally only had one color for all the data point
which i went through and began to manually change but I am wondering if there
is a setting or an option to enusre that they come in as different colors in
the first place.
--
Thanks,

Galen