dynamic pie chart
 

i want to have a pie chart in a sheet by itself, that shows the percent for
each state that has a percent (some have zero values). However the percent
values for each state change when i update another sheet in the workbook, i
want the chart to always select only the states that have non-zero values

i have set the names for the x and y series as follows

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

&

statevaluesY =OFFSET(statevalues,0,-1)

statechtdata has the name for the chart in a1 and the 50 states + DC in
a2:a52 and the coresponding percentages in column b

I tried to set the chart series to
=SERIES(statechtdata!$a$1,statechtdata!satevalues, statechtdata!statevaluesY,1)

this returns an error... any suggestions? (full disclosure I did not write
thsi code I found it on the web)
--
Thanks,

Galen