graph image -how to superimpose or extra data-point by VBA
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.
|