How to build the charts

[san1014]

Hi
I have a table like this
sql> select * from commodity;
commodity_id year value
---------------------- ------- ---------
C1 1996 20
C1 1998 39
C1 2000 45
C2 1990 170
C2 1995 200
C2 2000 480
C3 1983 10
C3 1987 45
C3 1991 230
C3 1995 125

How can i built the charts(line,bar ,charts) for year (Vs) Value for each commodity in java swings using Oracle chart builder.

[r035198x]

Hi
I have a table like this
sql> select * from commodity;
commodity_id year value
---------------------- ------- ---------
C1 1996 20
C1 1998 39
C1 2000 45
C2 1990 170
C2 1995 200
C2 2000 480
C3 1983 10
C3 1987 45
C3 1991 230
C3 1995 125

How can i built the charts(line,bar ,charts) for year (Vs) Value for each commodity in java swings using Oracle chart builder.

I don't know what Oracle chart bulider is but if it builds charts then what do you need swings for?
If you have to do it in Java then have a look at JFreeChart.

[san1014]

i hava a problem in charts.

i am having data without equal intervals in x-axis.
I want the data with equal intervals.

please give advice or code.

Thank u