Auto selection of Data

[Raz]

I have a chart with three different plots (line) on it. Each one generated
from different set of data.
One of the plot (line) that need to select data automatically from a table.
Its working if I select manually. I may have 10 to 100 rows of data in
different cases. Would it be possible for the plot to select data itself
???????

For example, If I have 10 rows of data I need to select those 10 rows (in
both columns), if I have 20 I need to select those 20 manually. Is there a
function I can add with this equation below to select data from the list
automatically.????

When I click on the line plotted this is what I see in Formulla bar.
=SERIES(,'JAXXN Report'!$K$97:$K$101,'JAXXN Report'!$E$97:$E$101,1)

 

[Shane Devenshire]

Hi,

You need to use dynamic range names. Jon Poltier has examples at his website:

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

Basically you define a name like X to be =OFFSET($A$1,,,COUNTA(A$1:A$100))

Then you use that name in the Source Data dialog box.