Importiong an Excell Chart in to Access

[Daveyk01]

Hello there,

Access 2000...

Following examples I found in this forum, I have been able to sucessfully open an Excell spreadsheet, select cells and paist data in to them and save the excel spreadsheet under a unique name.

It is very cool watching access open the sheet, edit it and close it! While it is punching in the new data, a Histogram on that sheets updates in real time. Too cool!

Now the problem. How do I copy that chart in to an access ole field? What commands do I need to use?

My table is designed with an ole field. Right now I am openening the spreadsheet, manually, highlighting the chart, right mouse clicking and selecting copy and then go back to my database form and right mousing and selecting paiste and it puts the chart in my access form and it looks great!

What code is needed to do that automatcially?

Thanks very, very much.

Dave

 

[RuralGuy]

Since *you* started this duplicate thread, when *you* edit the first post you have the option of deleting the thread. Go ahead and delete this duplicate and save the Mod's some work.

 

[Daveyk01]

Since *you* started this duplicate thread, when *you* edit the first post you have the option of deleting the thread. Go ahead and delete this duplicate and save the Mod's some work.

Don't know I "duplicated the thread". If is that much of a problem, I'll just delete it and search elsewhere on the WEB for the solution.

You have been most helpfull; thank you.

My first responce... a nice friendly one. <sigh>

 

[RuralGuy]

No offense intended just trying to save the moderators some work. Your skin seems pretty thin. If I had and answer for you I would have responded to the first thread.

 

[Daveyk01]

No offense intended just trying to save the moderators some work. Your skin seems pretty thin. If I had and answer for you I would have responded to the first thread.

I am abit stressed out <grin>. I have seen nasty stuff in other forums on the WEB and I took the *you* as an editque attach rather than helpfull.

I think I first posted the message under Ecel and the found out that was not an access forum. Didn't know I could delete it. Then I posted in in a Access forum to make sure access programmers could see it. My bad. I deleted the post in the Excel forum.

I appologize for the thin skin. I mad assumptions that I should not have.

 

[chergh]

Could you do something like:

dim xlchrt as excel.chart

xlchrt = excel.application.workbooks("name").worksheets("name").chartobject("name")

Then set your field = xlchrt

 

[The_Doc_Man]

Chergh, that doesn't work (I think) because the field will be of the wrong format. Make it a hyperlink field, maybe... but there is always the method of trying to duplicate the chart in Access, which ALSO has the ability to call MS Chart. The interface is uglier, but if you have an Excel chart, you already know the correct settings for the corresponding Access chart.

Search this forum for Charts and Graphs and other such keywords. You'll see all sorts of posts as it is a popular topic.

 

[Daveyk01]

Chergh, that doesn't work (I think) because the field will be of the wrong format. Make it a hyperlink field, maybe... but there is always the method of trying to duplicate the chart in Access, which ALSO has the ability to call MS Chart. The interface is uglier, but if you have an Excel chart, you already know the correct settings for the corresponding Access chart.

Search this forum for Charts and Graphs and other such keywords. You'll see all sorts of posts as it is a popular topic.

Is the chart parameters documented anywhere? I can get help for most items, but when I ask for chart help, my access states that the help file is installed and when I try it can't find it and suggests I re-install office (damn corporate PCs).

I don't think it is an option on the design toolbad. Under Active X controls there are some but those are totally undocumented.

Yes, if I could figure out the basics of using a chart on my native Access form that would be ideal and leave Excel totally out of it.

Is there any good books on ADVANCED access topics that may cover charts you can recomend that I purchase?

Thanks kindly,

Dave

 

[Daveyk01]

Chergh, that doesn't work (I think) because the field will be of the wrong format. Make it a hyperlink field, maybe... but there is always the method of trying to duplicate the chart in Access, which ALSO has the ability to call MS Chart. The interface is uglier, but if you have an Excel chart, you already know the correct settings for the corresponding Access chart.

Search this forum for Charts and Graphs and other such keywords. You'll see all sorts of posts as it is a popular topic.

Okay, I inserted a Microsoft Graph Chart. It has a small spreadsheet asociated with. How do I put the data points in to that spreassheet?

 

[Daveyk01]

By the way, here is what I am looking to creat with the Microsoft Chart Object. Please see attached. i have learned how to add data for 64 points by doing this:

rivate Sub Form_Load()
Dim db As Database
Dim rs As Recordset
Dim strSQL As String
Dim Graph_Data As Object
Dim objDataSheet As Object
Dim Z As Integer
'
Set Graph_Data = Me.ProbeHistogram.Object
Set objDataSheet = Graph_Data.Application.datasheet
'

For Z = 1 To 64
objDataSheet.Range("A" + Trim(Str(Z))).Value = "90%"
Next Z


End Sub

That Data would be from A1 to A64 and that does work. Now how to I tell the chart to use A1 - A64 in the X Axis?