Dynamic Charts where start is known, but end is unknown

  • Thread starter Thread starter Rcarper
  • Start date Start date
R

Rcarper

Hello,

I've recently been trying to find a solution for graphing the last 10 values
in a list of data, but the problem is (I'm using Peltier's example for
Dynamic Charts) is that I know where my start is (never at b1 or a1), but not
my end. However anything I throw into my graphing solution is giving me
random results. This is the first issue. The second issue is, I'm using the
same sheet to create multiple graphs that will be using these dynamic charts,
and once again it appears that the consistency in graphing is in error (aka.
looks correct one minute and garbage the next)
 
Yes I should have, my apologies. All of my names are similar to yours Jon
that you used in your example except here. This is the ChtCats name (All
others are the same as per example)

=OFFSET('Graphing Data'!$B$25,COUNTA('Graphing
Data'!$B$26:$B32),0,-MIN(ChtLen,COUNTA('Graphing Data'!$B$26:$B32)),1)

B25 = the name of what I'm doing (in this case date)
B26 = first date (this is for a calibrated item, ideally I'd like this date
to appear on the graph, but if not I think thats ok)
B27-B31 = Client data, this is noted by date, and ideally I only want the
last 10 of these which Jon your dynamic naming did perfectly. This list will
grow continually as more clients are entered
B32 = Final date that item was tested, this date is always shown (Once again
Jon your formula does this great)

Now this is only for 1 graph on this page, there are a total of 8 that are
created from this page. (Different sets of data).
 
I also want to note (although this may be obvious) the information of B32
shifts down as data is entered in.
 
I guess you know you need one name like this for each series of data.

What did you mean by the graphing solution giving "random results"? And what
parts of the graph looked good one minute and garbage the next?

- Jon
 
Actually this morning I think I solved the issue. I did this by putting
string notation in front of the '32'. I'm not sure why this works and that I
can insert lines with no issue. Thank you for all your assistance.

RC
 
Back
Top