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

  • Thread starter Thread starter Davyboom
  • Start date Start date
D

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.
 
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
 
Patrick Molloy said:
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
Click to expand...
 
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,
 
Back
Top