A most excellent solution.......... Ken
On Oct 23, 5:44 pm, anandydr <anand...@gmail.com> wrote: > Hi, > > One simple method would be to incase your formula in and IF formula > which can put NA( ) instead of zero. e.g. > =IF(COUNTIF(A1:A100,"T")=0,NA( ), COUNTIF(A1:A100,"T")) > > Excel would not plot NA in the charts and still the cells would be > included so your chart will go all the way to the right side even if > the last values in your series are zero. > > Hope that helps, > Anand Kumar > > On Oct 17, 12:29 am, Ken <ksgood...@gmail.com> wrote: > > > > > I have a sheet where I am listing the data (numbers) in columns. I add > > data at the bottom of the columns as I get it. I plot a single column > > of data using the offset function within a Named range to set the data > > to plot against the number of data points input; plus a few blank rows > > (e.g. 30) below the data to make the chart look good. > > > Named range "CashFlow" =OFFSET(Poker!$G$3,0,0,COUNTA(Poker!$G$3:$G > > $1004)+30,1) > > > Source for chart: Series Values =Poker.xls!CashFlow > > > I auto scale based on the offset function; testing for the data in the > > column. E.G. COUNTA. No issues there. > > > I am using another column to filter the data in the first column to > > show a subset of the data in the first column. I use formulas in the > > second column to filter the data. The formulas are filled in for a > > 1000+ rows. When I try the same technique to plot the second column I > > get the data plus a few rows below the data with zeros in the plot. > > e.g. The plot goes to zero at the end for the rows below the data with > > formulas in the cells. I have cut off the extra rows; it works; but > > does not look the same as the first chart. Specifically: Plot goes > > all the way to the right side of the chart. >> > > > Ideas on making the second plot with a few extra rows that do not plot > > as zeros? Where to add the rows? In the named range or in the source > > for the plot? And how?- Hide quoted text - > > - Show quoted text - -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
