Using chartspace in a user form
 

Is there anyone who can tell me how to use chartspace in a user form? I
want to use data from an array, which is loaded into memory.

/Ola Eriksson


---
Message posted from http://www.ExcelForum.com/

Using chartspace in a user form
 

If you want to show an Excel chart in a userform - there are some
workarounds.
Please see these examples by John Walkenbach and Stephen Bullen:

http://www.j-walk.com/ss/excel/tips/tip66.htm
http://www.bmsltd.co.uk/DLCount/DLCo...stePicture.zip

HTH
/Ulrik

"Ola " wrote in message
...
Is there anyone who can tell me how to use chartspace in a user form? I
want to use data from an array, which is loaded into memory.

/Ola Eriksson


---
Message posted from http://www.ExcelForum.com/

Using chartspace in a user form
 

If I use the Picture-method, where do I create the picture when I don´
have any data in a spread sheet? The data I want to use is uploade
from Access and calculated in VBA.

/Ol

--
Message posted from http://www.ExcelForum.com

Using chartspace in a user form
 

Look at the office Web components, there is a chart component.

I don't know if it will work with an array, however - you might have to use
the spreadsheet control to place the array first.

--
Regards,
Tom Ogilvy

"Ola " wrote in message
...
If I use the Picture-method, where do I create the picture when I don´t
have any data in a spread sheet? The data I want to use is uploaded
from Access and calculated in VBA.

/Ola


---
Message posted from http://www.ExcelForum.com/

Using chartspace in a user form
 

This macro adds a chart without needing data in the worksheet. You do
need a worksheet....

Sub ChartFromArrays()
Dim myChart As Chart
Set myChart = ActiveSheet.ChartObjects.Add(100, 100, 325, 250).Chart
With myChart
.SeriesCollection.NewSeries
.ChartType = xlXYScatterLines
With .SeriesCollection(1)
.Name = "The Series"
.Values = Array(1, 3, 5, 7, 9)
.XValues = Array(1.5, 2.5, 3.5, 4.5, 5.5)
End With
End With
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Ola < wrote:

If I use the Picture-method, where do I create the picture when I don´t
have any data in a spread sheet? The data I want to use is uploaded
from Access and calculated in VBA.

/Ola


---
Message posted from http://www.ExcelForum.com/

Using chartspace in a user form
 

Thank you, Jon!

I look into the code and get back if I run into any problems.

/Ola Eriksso

--
Message posted from http://www.ExcelForum.com