Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand Selection in Auto filter | Excel Worksheet Functions | |||
Drop down selection auto format | Excel Discussion (Misc queries) | |||
auto selection | Excel Worksheet Functions | |||
Auto Populate Based on Other Selection | Excel Discussion (Misc queries) | |||
# of Records Shown During Auto-Filter Selection | Excel Discussion (Misc queries) |