# Invalid Renderer Type for Dataset on Chart

**URL:** <https://forum.inductiveautomation.com/t/invalid-renderer-type-for-dataset-on-chart/110752>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [September 18, 2025, 1:32pm UTC](https://forum.inductiveautomation.com/t/invalid-renderer-type-for-dataset-on-chart/110752 "2025-09-18T13:32:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bill\_S](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bill_s/32/6705_2.png) [@Bill\_S](https://forum.inductiveautomation.com/u/Bill_S)\
**Post date:** [September 18, 2025, 1:32pm UTC](https://forum.inductiveautomation.com/t/invalid-renderer-type-for-dataset-on-chart/110752/1 "2025-09-18T13:32:15Z")

</div>

In 8.1.47 in Vision:

I’m strugging with classic chart configuration. I want to eliminate areas in the graph where there is no data to display. It looks like this:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/2/72ede08ebda95e79012656c3ba349b9f3216099a.png)

The MSSQL table contains data from several process cells. It includes the process cell name, measurement result, an index/row number, and a timestamp (SQL datatime). Like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/b/0b57ea8a7bc33af3db8c737da7e797f8365189cd.png)

My query for the chart returns data for just one selected line, so the index numbers are sequential but some are missing since I’m not returning data for all lines. Like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/0/50826fb7b1880f2aad6602deebe735fef2f07d78.png)

I’ve tried to chart the data by treating the Index numbers as catagories. I config the X axis to be a catagory-type axis and configure that axis to be used in the dataset properties tab.

When I save that configuration I get the following errors:

_Invalid renderer type for dataset "Data" on chart "Chart 2". Please use XY renderer._

_Axis 'Catatory2' is the wrong type._

_It is a CategoryAxis and it must be a ValueAxis_

_ClassCastException: class org.jfree.chart.plot.PiePlot cannot be cast to class org.jfree.chart.plot.XYPlot (org.jfree.chart.plot.PiePlot and org.jfree.chart.plot.XYPlot are in unnamed module of loader java.net.URLClassLoader @a643a7b)_

I’ve also tried CAST and CONVERT on the Index number to convert it to a string in the chart dataset. When I do that I only get the last error ClassCastException.

I’m missing something in either the configuration or the dataset, but I can’t figure it out.

What am I missing here? Anyone have any suggestions?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 19, 2025, 4:04pm UTC](https://forum.inductiveautomation.com/t/invalid-renderer-type-for-dataset-on-chart/110752/2 "2025-09-19T16:04:11Z")

</div>

The 'Chart' component requires you to make a series of changes to properties if you're switching from XY to Category mode, or vice versa:

> **[Using the Classic Chart | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/ignition-modules/vision/historian-in-vision/using-the-classic-chart#chart-type-xy-vs-category)**
>
> Chart

---

<div class="post-metadata">

**Author:** ![Bill\_S](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bill_s/32/6705_2.png) [@Bill\_S](https://forum.inductiveautomation.com/u/Bill_S)\
**Post date:** [September 19, 2025, 7:00pm UTC](https://forum.inductiveautomation.com/t/invalid-renderer-type-for-dataset-on-chart/110752/3 "2025-09-19T19:00:49Z")

</div>

I’m so dense!

I was so focused on the query and the chart customizer that I forgot to change the chart type in the properties!!!

Thanks Paul, your reply was what I needed to find my error.