Category Chart Alphanumeric x-Axis in Report

I would like to get something like this in a Report
image

The x-Axis is alphanumeric. I would like to use XYChart or maybe BarChart is a best option?
The way to take this is by Scripcting using JFreeChart object but I'm not sure how thw syntax should be to modify the axis type.
Please some help!

Is that even possible in a report?

I’ve made some progress in XYChart
image

but I can not delete those gray bars. No matter how much I set up some properties. Does anybody knows how to deal with it?

How did you get the report xy chart to work with categorical data?

Mine looks like garbage, and it keeps converting text to numerical values.

I am still stuck on getting the Report XY chart to scale categorical X axis values.
Need some help.

My first column is like "Jul 2023".
When I try to get the chart to work the string is converted to a number for some reason.
8.1.30

I was there 3000 years ago.

I remember I accomplish this with numerical axis, it's not categorcial. I used a JFreeChart class to overwrite numeric label with text. XY Chart was used.

1 Like

How do I replace the labels?
I never did that before.

I thought the point of XY chart is to be categorical instead of time oriented.

Maybe I am lucky as this time I can probably switch to using time series.
It would be good to know how to get categorical values on the label.

No, by default an XY chart expects numbers on both axes. So you can plot a function of X and Y. (Hence the name.)

SymbolAxis (JFreeChart 1.5.0 API)

1 Like