Calculated range reference in graph

From: Compcat (Compcat_at_discussions.microsoft.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 10:59:08 -0700

=QTData!$E$2:"$E$"&COUNTA(QTData!E:E) gives an error in the graph X Values
field. I want to graph some data that I load from Access. The problem is
that I do not allways want to plot the same number of points. What I hoped
would work is just to concatenate the calculated end to the range statement.
How do I make this work?

Relevant Pages

  • Help needed in ploting graphs in GUI
    ... I am trying to make a graph in the GUI which plots itself ... when the user pushes a pushbutton. ... plot the current data as well as the previous data. ...
    (comp.soft-sys.matlab)
  • Problem with sin/cos of complex signal
    ... You'll see if you run it that the signal appears to graph ok in both real and imaginary, but the sin and cosine don't appear to have anything to do with the signal itself. ... %LAB1_SEC3.1_SOURCE_CODE quick script to run part of lab 1 ... plot; ... title('Imaginary Sample Data, Lab 1 Section 3.1'); ...
    (comp.soft-sys.matlab)
  • change avi source files in real-time
    ... this sample loads "wFileName" and play it. ... I want to stop current AVI and want to load new AVI file. ... // Register the graph in the Running Object Table ... // instead of allowing the Filter Graph Manager to render all pins. ...
    (microsoft.public.win32.programmer.directx.video)
  • Re: help with design - reload image on image load; avoid infinite loop
    ... to the graph image. ... Just remove the event listener ... It depends on the DOM which elements support the `load' event, ... and which DOM objects may also support the proprietary `onload' ...
    (comp.lang.javascript)
  • Re: Updating a Graph in word
    ... This object was created in MS graph. ... get the info from the form but am finding it difficult to plot the ... The graphing engine is the same one Excel uses. ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.vba.general)