Using variables in Chart Ranges

[Guest]

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

 

[Jon Peltier]

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/
_______