Newfs_R_Sublime
Board Regular
- Joined
- Jan 20, 2011
- Messages
- 99
<TABLE class=tborder id=post2649965 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2649965 style="BORDER-RIGHT: #ffffff 1px solid">I have sorted data that I use to compose several charts. However, I need to be able to run some of those charts based on when the value in G becomes 0 (I can make it #/N/A to make it easier). For example:
The total data is between a2:k95. G became 0 on row 80.
I need to dynamically change my chart parameters so I can run charts between A2:K95, A2:K79, and A80:K95.
The data is not always the same length. So 95 was just the example for today. tomorrow it could be 86 and G become 0 on 81.
An indirect feature within the charts would have been fine, but that doesn't work-at least the way I tried.
I'm sorry , I created an area where the values of the data length and row where G became 0 can be entered
Thank you.
Rick
<!-- / message -->
</TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid"></TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls --><!-- / controls --></TD></TR></TBODY></TABLE><!-- post 2649965 popup menu -->
<TABLE cellSpacing=1 cellPadding=4 border=0><TBODY><TR><TD class=thead></TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/member.php?u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/private.php?do=newpm&u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/search.php?do=finduser&u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/profile.php?do=addlist&userlist=buddy&u=169844</TD></TR></TBODY></TABLE>
<!-- / close content container --><!-- / post #2649970 --><!-- post #2650026 --><!-- open content container -->
The total data is between a2:k95. G became 0 on row 80.
I need to dynamically change my chart parameters so I can run charts between A2:K95, A2:K79, and A80:K95.
The data is not always the same length. So 95 was just the example for today. tomorrow it could be 86 and G become 0 on 81.
An indirect feature within the charts would have been fine, but that doesn't work-at least the way I tried.
I'm sorry , I created an area where the values of the data length and row where G became 0 can be entered
Thank you.
Rick
<!-- / message -->
</TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid"></TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls --><!-- / controls --></TD></TR></TBODY></TABLE><!-- post 2649965 popup menu -->
<TABLE cellSpacing=1 cellPadding=4 border=0><TBODY><TR><TD class=thead></TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/member.php?u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/private.php?do=newpm&u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/search.php?do=finduser&u=169844</TD></TR><TR><TD class=vbmenu_option>http://www.mrexcel.com/forum/profile.php?do=addlist&userlist=buddy&u=169844</TD></TR></TBODY></TABLE>
<!-- / close content container --><!-- / post #2649970 --><!-- post #2650026 --><!-- open content container -->
