View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
sri sri is offline
external usenet poster
 
Posts: 37
Default I need help with Excel 2007 and VB6 OLE Control

Guys,

I have an excel chart designed in Excel 2003 and worked great on all Excel
2003 machines when inserted into VB6 OLE control. When I have installed Excel
2007, Excel 2003 chart does not work anymore. If I set the OLE size property
to clip, OLE control simply shows very little of the chart on top left corner
of the control leaving the rest of the control blank. If I set the OLE
control size property to AUTOSIZE, it is ZOOMING the chart so big, it looks
ugly and does not fit in the OLE control on the VB6 form.

I really could use some help as I have already spent enough time to stress
myself with project deadline. So guys please help me out if you know what to
do!!

Thanks a lot