G
Galen
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)
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)