Zoom Percentage to fit a graph on the sheet

[ajetrumpet]

Folks,

I have created a graph on my excel sheet for quotation purposes, and I sent it to another person the other day for review. They have 07, and they said that when they opened the book, my graph and text box for the title had extended off the sheet (to the right, not to the bottom). It was all created with 03 by me.

I know these facts:

1) The zoom percentage does not change from the time the book is closed until the it is opened again. There is no default. It is what it is changed to.

2) I had sent it to my reviewer at 100% normal view, and that's when he made his claim of the shifting off the sheet.


My question is: Does this have anything with the extra space the ribbon menu takes up in 07? It certainly shouldn't have. He's an older guy, so I question what he tells me. It just doesn't make sense. I don't want someone to open a package like that and have it look like crap. That would not be good, and I certainly wouldn't get any business from it!

Any thoughts appreciated..

 

[chergh]

Probably his monitor resolution

 

[Bilbo_Baggins_Esq]

It may well be extended off the bottom as well, but if the chart elements are still bisible, it was not mentioned.

Most likely the monitor resolution.

Is the chart in a worksheet or is it in its own page?
If you place it is ins own page, I think it should scale when opened.

 

[ajetrumpet]

As a follow up to this folks, I found code to check the resolution of a windows machine (XP and Vista):

'*****************************************************************
' DECLARATIONS SECTION
'*****************************************************************

Option Explicit

Type RECT
   x1 As Long
   y1 As Long
   x2 As Long
   y2 As Long
End Type

' NOTE: The following declare statements are case sensitive.

Declare Function GetDesktopWindow Lib "User32" () As Long
Declare Function GetWindowRect Lib "User32" _
      (ByVal hWnd As Long, rectangle As RECT) As Long

'*****************************************************************
' FUNCTION: GetScreenResolution()
'
' PURPOSE:
'   To determine the current screen size or resolution.
'
' RETURN:
'   The current screen resolution. Typically one of the following:
'      640 x 480
'      800 x 600
'     1024 x 768
'
'*****************************************************************
Function GetScreenResolution() As String

   Dim R As RECT
   Dim hWnd As Long
   Dim RetVal As Long

   hWnd = GetDesktopWindow()
   RetVal = GetWindowRect(hWnd, R)
   GetScreenResolution = (R.x2 - R.x1) & "x" & (R.y2 - R.y1)

Debug.Print GetScreenResolution

End Function

I assume this works on all windows machines alike (XP and Vista). I am thinking of sending out my Excel application and changing the resolution to the standard that is found on all machines (1024 x 768). This looks fine on some machines, but not as good on others. Can anyone advise on liability issues that could come up with this? I am thinking of popping up a message box to warn the user that the resolution has been changed to fix graphs on the screen. Would this be OK? I assume there is no liability here because RES. changes has nothing to do with hardware crashes and the like (i hope!). Thanks...

 

[Bilbo_Baggins_Esq]

I personally would not start changing users resolutions on their machines.
There could be substantial issues with monitor capabilities, video card cababilities, refresh rates, etc.

Why don't you want to simply put the chart in its own sheet?

BTW, just last week, I installed a db on a customer's machine that insists on running at 800x600.

What detail could be present in this chart which is lost at low resolution?

 

[ajetrumpet]

This is a quotation system Bilbo. When the users select the criteria from the dropdown boxes, the graph appears with the quotation for services, and the text boxes disappear. Wouldn't putting the graph in its own sheet complicate things for a business person?

 

[ajetrumpet]

Forget it Bilbo. I have figured out another way. I am just going to inform the user to adjust the zoom of the sheet. thanks anyway.