Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hubris00
 
Posts: n/a
Default 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   Report Post  
Hubris00
 
Posts: n/a
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Area chart Disappears ASU Charts and Charting in Excel 1 August 24th 05 01:47 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Resize chart area without resizing plot area Janwillem van Dijk Charts and Charting in Excel 2 August 2nd 05 01:52 AM
How do I alter plot area colour in a chart without a mouse? debbiecatal Charts and Charting in Excel 2 May 30th 05 04:11 AM
Area Chart Formatting Question Avrilon Charts and Charting in Excel 3 December 2nd 04 09:14 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"