Re: Updating a Graph in word

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Cindy,

Thanks for reply. No I have tried just running that line (Set oleF =
doc.InlineShapes(1).OLEFormat - in fact that shouldn't have been in
the post as it was one of test lines I had tried out) and it gives me
an error saying:

This object was created in MS graph.
This application is not avaliable to open this object.
Make sure the application is properly installed and that it has not
been deleted, moved or renamed.

I have read else where that this is related to objects embedded in
embedded objects but I am not sure how this applies. All I want to do
is to plot and then update an array which I can't think can be that
differcult - although I am finding it really difficult to find a
solution!

Hope you can help me further.

Best regards

Matthew

On 18 Dec, 08:23, Cindy M. <C.Meiste...@xxxxxxxxxx> wrote:
Hi Matthew

I have a user form from which I want to plot agraph. I know how to
get the info from the form but am finding it difficult to plot the
graph. I have got the code below from another website which seems to
do what I want (e.g. plot agraph) but it inserts a newgrapheach
time you run the code. I am sure it is due to the line I have marked
"here" but I don't know how to change it to reference an existing
graph? Also I am not sure how to add a second series to thegraph?

Yes, that would be where the problem is coming from. Does it not run
if you leave this line commented out, so that this one runs?

    Set oleF = doc.InlineShapes(1).OLEFormat

To get help with setting up series, I recommend you ask in an Excel
newsgroup. The graphing engine is the same one Excel uses. Be sure to
mention which version of Office you have, as the graphing engine
changed in 2007.

Cindy Meister
INTER-Solutions, Switzerlandhttp://homepage.swissonline.ch/cindymeister(last update Jun 17 2005)http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Re: Updating a Graph in word
    ... get the info from the form but am finding it difficult to plot the ... do what I want (e.g. plot a graph) but it inserts a new graph each ... The graphing engine is the same one Excel uses. ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.vba.general)
  • Re: [opensuse] Lies, damned lies and statistics
    ... Recently we have done a poll around the office. ... line with bash/sed/awk and then produce graphs from that, then spline, graph ... GNU 'plot' is then called to display a graph on the screen: ...
    (SuSE)
  • Re: WMP 11 and uncompressed streams
    ... following the advice of Neil Smith, I post my problem on this newsgroup. ... The issue is that CheckMediaType is called once ... WMP10 steps to build the graph: ... 1/ CheckMediaType for decoding input format ...
    (microsoft.public.windowsmedia.sdk)
  • 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)