# Multiple X axis chart

**URL:** <https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [March 28, 2024, 11:20pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057 "2024-03-28T23:20:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Faz](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@Faz](https://forum.inductiveautomation.com/u/Faz)\
**Post date:** [March 28, 2024, 11:20pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/1 "2024-03-28T23:20:40Z")

</div>

Hi all,  
I'm trying to build this chart with two categories in X axis. This is my data looks like in SQL  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/e/9e8c4cfbeff01c0315e89308c5dfa016ab8b6a52.png)

Is it possible to create a chart like this (this was made in Excel)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/3/63d502a176630acad0e0b09a1c335242698ba075.png)

---

<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:** [March 28, 2024, 11:25pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/2 "2024-03-28T23:25:22Z")

</div>

Are you working in Vision, Perspective, or the Reporting module?

---

<div class="post-metadata">

**Author:** ![Faz](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@Faz](https://forum.inductiveautomation.com/u/Faz)\
**Post date:** [March 28, 2024, 11:30pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/3 "2024-03-28T23:30:08Z")

</div>

Sorry I should've mentioned: it's Vision module

---

<div class="post-metadata">

**Author:** ![Faz](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@Faz](https://forum.inductiveautomation.com/u/Faz)\
**Post date:** [April 2, 2024, 9:16pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/4 "2024-04-02T21:16:52Z")

</div>

I'm guessing this is not doable in Vision?

---

<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:** [April 2, 2024, 9:27pm UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/5 "2024-04-02T21:27:51Z")

</div>

It's probably _possible_ via the configureChart extension function, but I don't have any examples at hand nor the time to figure it out, unfortunately. Someone else may be willing to volunteer their time. I'd suggest searching this forum "Jfreechart" to get a starting point. You probably want to supply a custom renderer for the chart items.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [April 3, 2024, 8:24am UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/6 "2024-04-03T08:24:28Z")

</div>

Just taking a quick look at this, it looks like it would be fairly trivial to do with a classic chart. The chart barked at me a bit as I was modifying its configuration, but once everything was changed over, it worked.

**Example**  
**1.** Start by changing the chart type to a category chart:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7e5aac3d8c2f76c77385c2261d885919a7ac6d6b.png)  
**2.** Right click on the chart and select "Chart Customizer"  
**3.** Hit the plus icon in the upper right corner of the Datasets tab, and add a second dataset for the secondary x-axis:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/3208e592622ed4048b65b84a52a64b1fe8dc00e4.png)  
**4.** Switch to the X-Axes tab and create a new category axis by clicking on the "+" icon in the bottom left corner of the customizer:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/3/b3839412ba49a1691b3a7770a0145e0d8920e0c5.png)  
**5.** Use the "X button to delete the Default X Axis, and recreate it as a category axis  
**6** Configure the label orientations of the two x axes:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/382e96213199ff01151ddf9c275dcf52dfe56ae1.png)  
**7.** Okay the changes that have been made so far, and add the desired secondary labels to the second dataset  
**8.** Switch to the Dataset Properties tab, and assign the second dataset's X Axis property to the second dataset: Set both datasets Renderer properties to "Category Bar Renderer"  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/1/61e308b8ec8e5ecbd21e94e80cde7f8b86517e56.png)

**Result:**

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

---

<div class="post-metadata">

**Author:** ![Jesse\_Dale\_Gimenez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesse_dale_gimenez/32/68763_2.png) [@Jesse\_Dale\_Gimenez](https://forum.inductiveautomation.com/u/Jesse_Dale_Gimenez)\
**Post date:** [October 9, 2024, 5:49am UTC](https://forum.inductiveautomation.com/t/multiple-x-axis-chart/88057/7 "2024-10-09T05:49:11Z")

</div>

Hi Justin,

Is this possible using perpective?  
I dont see the chart category chart selection when using xy chart or bar chart.
