Microsoft Chart Object - How to assign the X-Axis to a column of data

[Daveyk01]

I figured out how to send data to a chart object datasheet. By default the chart is based on A2, B2, C2 & D2 and then three rows of each.

I have 64 data elements that I want to plot in to a histogram (see attached histogram from excell). I have a loop program A1 (or A2) through A64 data. Now how do I get the X-AXIS of the histogram chart assigned to that column of data?

 

[Daveyk01]

One more question along this line.

Can the resulting graph/picture be saved in a field in a table (such as a scanned in picture can be saved in an ole field)?

If so what commands would I use?

rs.Fields(69) = Graph_Data.Object <- does not work

Field 69 ("Histogram") is set as an ole object in the table design.