Thread: Using variables in Chart Ranges

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:

http://peltiertech.com/Excel/Charts/Dynamics.html

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

"naprw@hotmail.com" <naprw@hotmail.com@discussions.microsoft.com> wrote in
message news:3A1F1B02-6407-450A-8B85-89A27338615C@microsoft.com...
>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
>
>