Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel chart size too big

Status
Not open for further replies.

donishere

Programmer
May 7, 2002
101
I'm trying to make a new chart in Excel. I use:

Set crt = ws.ChartObjects.Add(20, 20, 700, 450)

Doesn't this mean the chart I make will be sized 700x450 pixels? When I went to make my chart, it ended up being 935x601 pixels.

What's going on?
 
object.Add(Left, Top, Width, Height)

object Required. An expression that returns a ChartObjects object.

Left, Top Required Long. The initial coordinates of the new object (in points), relative to the upper-left corner of cell A1 on a worksheet or to the upper-left corner of a chart.

Width, Height Required Long. The initial size of the new object, in points. Thank you,
Dave Rattigan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top