Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
What is the relationship between .ChartArea and the default printer ?
Hello,
I am currently programming some automated charting for an application. In my program I modify the size of the charting area (the goal is to obtain a plot area -inside- that fits exactly some pre-defined dimensions). In order to observe what's going on when I modify some properties, I use the following code: Sub PrintSizes(strMessage As String) MsgBox strMessage & vbCrLf & _ ".ChartArea.Width = " & ActiveChart.ChartArea.Width & vbCrLf & _ ".ChartArea.Height = " & ActiveChart.ChartArea.Height & vbCrLf & _ ".PlotArea.Width = " & ActiveChart.PlotArea.Width & vbCrLf & _ ".PlotArea.Height = " & ActiveChart.PlotArea.Height & vbCrLf & _ ".PlotArea.InsideWidth = " & ActiveChart.PlotArea.InsideWidth & vbCrLf & _ ".PlotArea.InsideHeight = " & ActiveChart.PlotArea.InsideHeight End Sub I noticed that the .ChartArea properties do not react the same way if my default printer is a HP or a Xerox. I could not find an article describing how does the default printer govern those parameters. Does any know where to find such information ? Thank you for your help, Xavier |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|