View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
davyboom davyboom is offline
external usenet poster
 
Posts: 9
Default graph image -how to superimpose or extra data-point by VBA

Thanks to Patrick.

Can your prgoram work if my image file is of JGP type. The yeild curve from
web is of Java and could only be snapped by prt-screen.

thanks,


"Patrick Molloy" wrote:

assuming you have an image oject and a chart object then:


Sub Main()
Dim ch As ChartObject
Set ch = Sheet1.ChartObjects(1)
With Sheet1.Image1
ch.Top = .Top
ch.Left = .Left
ch.Height = .Height
ch.Width = .Width
.BackStyle = fmBackStyleTransparent
.BringToFront
End With



End Sub

"Davyboom" wrote:

I got 2 yield curve image files and need tooverlay the yield curves for
coparison.
How to program in VBA to
1. superimpose the 2 grah pciture, or
2. get data point direct such that can re-plot in one graph.