I will sometimes create a similar chart in Excel and then record a "maco"
while I change properties of the chart. Afterward, I copy and paste the code
into Access. Sometimes I have to modify the code but it at least gets me
kick started.
I will try to do exactly that to see if I can access the charts properties
in vb and get it to do what I want. Like most people it seems, I am having a
go at developing an interactive stock market charting package
I think a little more explanation of my needs is required. I don't just need
to chart data. I need to be able to make edits to the chart at runtime. i.e.
adding lines and text which can then be stored to the native database for
the chart and be displayed exactly as they were created the next time the
chart is displayed. Can anyone help?
I don't think Access can do this without a LOT of work. Displaying results
of numbers is not that difficult. Creating and storing mark-up information
adds a level of complexity that would require a third-party application.
I was aware this will be difficult, but I have already invested a heap of
time in this and don't want to abandon it. If you have any useful samples
they would be much appreciated
I would consider rolling my own. I have a report in the Corp Tech Demos at http://www.invisibleinc.com/divFiles.cfm?divDivID=4 that creates charts with
labels without using a graph control. You could store your markup
information in a table that sets the position. This would only work in a
report.