Query and graphs

[suha]

Hi

I have an application where i have to show data in a graphical way (pie,or any type of graphs), and this step is a very important output to complete this project.
The first time everything is ok but when the data is changed:

How could i update the datasheet of a graph obtained by a certain query whenever relevant data in a table changed.

How to relate the datasheet of a graph with the output file of the query.
otherwise i have to process the query again and choose type of chart and x-axis name, y-axis name...etc and this can't be given for the end-user to handle.

If there is anybody used the graphs before as an output help me or inform me where i can find topics or programs related to the subject.


i'm waiting for your help

suha [sig][/sig]

 

[TomasDill]

Suha, try to seach MS knowledge base.
Personally, I use Tee Chart for any kind of graphical charts. Many other programmers use third-praty ActiveX controls too (there are plemty of them), because they're easy to use, easy to program, could be placed on form as separate control, allow much more functionality etc.
[sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]