# Chart - X axis sequence for pareto chart

**URL:** <https://forum.inductiveautomation.com/t/chart-x-axis-sequence-for-pareto-chart/7594>\
**Category:** Ignition\
**Created:** [November 20, 2013, 2:59pm UTC](https://forum.inductiveautomation.com/t/chart-x-axis-sequence-for-pareto-chart/7594 "2013-11-20T14:59:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![momoore](https://avatars.discourse-cdn.com/v4/letter/m/a87d85/32.png) [@momoore](https://forum.inductiveautomation.com/u/momoore)\
**Post date:** [November 20, 2013, 2:59pm UTC](https://forum.inductiveautomation.com/t/chart-x-axis-sequence-for-pareto-chart/7594/1 "2013-11-20T14:59:15Z")

</div>

Creating a pareto chart using the chart control with data from sql query. I have the data pulling into the chart and changed it from line to bar render, but having an issue getting the chart not to arrange the x axis data from from least to greatest based on the number returned. My x axis value is state number and I am evaluating how man times the state number occurs.

In a regular bar chart returns correctly from order of highest frequency to lowest from an order by statement in my sql query.

In a standar chart when I use bar render re-orgs by value of state number 0-8. So I basically want the x axis values to appear in the order by query returns them, not auto arrange from least to greatest of the state number returned.

I have attached a sample image to show differences in the returns of the two charts. I am sure this is a simple oversight on my part of the properties of the x axis data on chart customizer just not finding it.  
 ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:")

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [December 27, 2013, 12:36am UTC](https://forum.inductiveautomation.com/t/chart-x-axis-sequence-for-pareto-chart/7594/2 "2013-12-27T00:36:26Z")

</div>

It looks like this is fixed (at least in 7.6.4) but you have to be careful about your category names across multiple datasets.