# Category Chart Alphanumeric x-Axis in Report **URL:** \ **Category:** Ignition\ **Created:** [July 13, 2020, 11:37pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666 "2020-07-13T23:37:29Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [July 13, 2020, 11:37pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/1 "2020-07-13T23:37:29Z")
I would like to get something like this in a Report ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/4/04a8a58c4905e39eb5609a0d6381105a1ca98da7.png) 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? ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [July 14, 2020, 7:24am UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/2 "2020-07-14T07:24:59Z")
I’ve made some progress in XYChart ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/c/dc4258b28ec4dbffcbad630b1793bb951be81152.png) 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? ---
**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Post date:** [March 1, 2024, 2:18pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/4 "2024-03-01T14:18:32Z")
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. ---
**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Post date:** [March 4, 2024, 1:17pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/5 "2024-03-04T13:17:29Z")
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 ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [March 4, 2024, 2:20pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/6 "2024-03-04T14:20:25Z")
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. ---
**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Post date:** [March 4, 2024, 2:22pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/7 "2024-03-04T14:22:49Z")
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. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 4, 2024, 4:43pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/8 "2024-03-04T16:43:51Z")
> [@Zach\_Larson](#): > > thought the point of XY chart is to be categorical instead of time oriented. No, by default an XY chart expects numbers on both axes. So you can plot a function of X and Y. (Hence the name.) ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [March 4, 2024, 7:07pm UTC](https://forum.inductiveautomation.com/t/category-chart-alphanumeric-x-axis-in-report/36666/9 "2024-03-04T19:07:38Z")
[SymbolAxis (JFreeChart 1.5.0 API)](https://www.jfree.org/jfreechart/api/javadoc/org/jfree/chart/axis/SymbolAxis.html)