software

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
You have to create a named range (variable) that describes the entire range,
not just part of it, or a dimension of it. Then this variable can be used in
the chart. Here are some examples and links:

peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

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