Displaying data on X-axis and Passing Parameters

ponic · Post by **ponic** » Wed Oct 19, 2005 11:59 am

Hello,

I have stacked bar and getting values using sql, I have three columns namely org_id, emp_count and non_emp_count. If I use one more columnm ,y graph is getting changed.

What I wanted is I want to add one more column(org_name) and show those values on my X-axis instead of the org_id. The parameter I am passing should be still org_id(category).

How can I do this?

Any help is highly appreciable.

Post by **david.gilbert** » Wed Oct 19, 2005 4:52 pm

I don't understand your description.

ponic · Post by **ponic** » Wed Oct 19, 2005 6:12 pm

Sorry that i didn't explain properly!

This is my query

select org_id,tot_emp,tot_non_ from org_det

I am passing org_id(category) as the parameter.

(rend.setItemURLGenerator(new StandardCategoryURLGenerator("xy_chart.jsp","series","category"));

If I use org_name in the query, the stacked bars are getting changed, one more stacked is added to the JDBCCategoryDataset. What I wanted is add the org_name as a desription on the Y-axis, at the same time I don't want add one more stack to the bars.

Thanks