I have created a chart with a Value (data range) of €˜='Raw Data'!$S$3:$S$6
but I need to make the number of rows to chart variable. I have created a
variable called €˜numrows with the COUNTA option. How do I replace the $S$6
with numrows so when I import data into the Raw Data worksheet, the proper
number of rows will be charted?

Thanks