| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
graph image -how to superimpose or extra data-point by VBA
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
graph image -how to superimpose or extra data-point by VBA
"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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you superimpose a graph onto another? | Charts and Charting in Excel | |||
| on bar graph, how to superimpose line of average values over bars | Charts and Charting in Excel | |||
| Excel should let you graph every n-th data point in a column | Charts and Charting in Excel | |||
| How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
| How can I add a caption for each data point in a bar graph? | Charts and Charting in Excel | |||
Linear Mode
