Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart- curve dropping to zero ( chart type- Line) | Charts and Charting in Excel | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
Dynamic Chart Range and Chart Update | Excel Programming |