How to capture Chart in Image Object

  • Thread starter Pauline Ohanian
  • Start date
P

Pauline Ohanian

Hi

I have a form done in VBA. I have an Image Object in the form. I am
generating a Chart and want to show the Chart on the form - in the Image
Object... Can anyone tell me what is the right syntax?

**************
ActiveChart.Location Where:=xlLocationAsNewSheet
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Avg. Profit vs Order Qty."
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Order
Qty."
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Avg. Profit"
End With
Image1.??? = ????
*************
This is where the Chart is being generated. I need to assign it to Image1.
But dunno how.


TIA,
Pauline.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charts in Multiple Sheet in Excel 1
reverse axis not working as before... 0
Compile error in 2003 3
Coding the series collections of a chart 1
Date values not appearing correclty in the x-axis 1
Issue creating charts in excel sheet 2
Excel 2007 won't execute 2003 VBA code 4
How to change the row number in macro code? 1

Top