graph image -how to superimpose or extra data-point by VBA

[Davyboom]

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.

 

[Patrick Molloy]

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]

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]

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,