If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto selection of Data
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) |
#2
|
|||
|
|||
Auto selection of Data
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Raz" wrote: 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) |
Thread Tools | |
Display Modes | |
|
|