How to sort X-Axis of Bar chart in Custom order.

Sai krishna

Hello,

I have to display a bar chart. In the dataset i have an custom ordered column values. When i have used that dataset to the chart it was displaying that column values in x-axis. But it was getting ordered in Alphabetical order. But it need to be get displayed in custom order as i have given in sql. Please anyone help me. I am struggling with this issue since 3 days.

Thanks,
Sai Krishna

jfranken

Click the icon on the Select Data tab of the chart editor to open the Grouping and Sorting window. Click the "fx" icon to open the expression editor.

Choose a sort order and enter an expression to sort the data. The pictured sort moves "company C" to the first item on the X axis.

Sai krishna

Hello Jeff,

Thank you so much!! It was working fine. Sorry for my late reply.

Thanks,
Sai.