Re: Creating graphs of SQL data using ODBC

Try this

http://www.mvps.org/access/downloads/chartex.zip

Nice graph example, but you must modify for linked oracle tables

Snewber wrote:
> Does anyone know of any software which allows you to make graphs of sql
> data quickly and easily?
>
> Ideally you would write a query which would probably return two columns
> (possibly more depending on how good the software was), x and y, and it
> would then generate a graph for you. I guess you would then be able to
> fine tune it to get what you want.
>
> I realise you can do this with spread sheets, but I'm looking for
> something simpler. It can be done by using access to link to your oracle
> database and then using excel to use the tables from access linked to
> oracle. This way you can then change the data in your oracle database
> and then refresh the excel graph and it updates the graph. But I would
> prefer a simpler way of doing this.
>
> Keywords: ODBC SQL graphs graphing software tools
Received on Fri Aug 26 2005 - 17:33:36 CEST