+ Reply to Thread
Results 1 to 2 of 2

Scatterplot chart area changes size on different systems

  1. #1
    Hubris00
    Guest

    Scatterplot chart area changes size on different systems


    Hi,

    I'm using VB to automate Word & MSGraph to generate an XY
    scatterplot. Everything works perfectly on my system (Windows
    2000/Office 2000 with current service packs).

    However, when a client uses the same VB app, with the same operating
    system and the same Office version, the scatterplots change size...

    when the client uses the VB app on Windows XP with office 2000 the
    scatterplots come out at the correct size.

    The plots are insrted into a table cell in Word, and their Height and
    Width are set as InchesToPoints(4.44)...


    We've tried changing every option in Tools.Options, but no luck.
    We've also tried changing the Display Settings.Advanced.Font Size to
    match...

    nothing has worked.

    Has anyone else seen this kind of behavior?...and found a solution??

    Thanks,
    -Chris


    --
    Hubris00

  2. #2
    Hubris00
    Guest

    Re: Scatterplot chart area changes size on different systems


    I may have found my own solution.... I'll post here for any other lost
    souls..

    I had a thought that the difference between systems might have been
    Word's Normal.dot file, which is the base template for New documents.
    So I created my own .dot file and included it with the VB app
    distribution, and used it as a template when creating the new Word docs
    with the sctterplot graphs.

    VB6 code:
    Dim oWord As Word.Application
    Dim oDoc As Word.Document

    'Start Word and open the document template.
    oWord = CreateObject("Word.Application")
    oWord.Visible = True
    oDoc = oWord.Documents.Add (Template:= _
    App.path & "\Template.dot" _
    , NewTemplate:=False, DocumentType:=0)

    So far so good, the client is reporting no scatterplot distortions...

    Hope this helps someone else.

    -Chris


    --
    Hubris00

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1