programming chart values

[zyx]

hi,

I'm trying to programmatically add values to my chart. ie manually enter plot values rather than have a table or query as the source.

Can anyone help?

thks

 

[Carol]

I really don't think that you can do this. I have made dozens of charts for reports and each chart still requires an underlying source to base its information on.
Just a thought, but you might be able to have a form with an underlying table with fields such as Value1, Value2, Value3, etc., which you could fill in a form and then requery to produce the graph automatically, thereby allowing you to basically plot the values at runtime.

Someone else may have some better ideas??

 

[joeyreyma]

i think Carol is right about the built-in chart feature of Access. Try third-party add-ons or the Microsoft Chart Control.

 

[kaspi]

It is actually possible to enter the values through the DataSheet - Range objects from the Graph hierarchy. However, I would not recommend using it, reason is that the graph is quite difficult to program and tend to be unstable.