Line graph X-axis values sorting

[markgraham123]

Hi,

I have a data like

Product   Sales

1          100

2          25

3           50  

4          15

I wanna plot Product on X-axis like 4 2 3 4 but not 1 2 3 4 so as to get the continuous line.

Can anyone help me

Attached is my current applicaiton.

[sunny_talwar]

Hey Mark

I think you forgot to attach. Please attach it again.

Best,

Sunny

[markgraham123]

Hi Sunny,

How are you?

Here is my attachment.

[giakoum]

use dual when you load product. text can be the product name and number the order you need it.

if you sort by product in your chart, it will sort by number not text

[Kushal_Chawda]

Create a line chart with Dimension: Product & Expression : Sum(Sales)

Now go to chart properties and go to sort Tab, check Y-value Ascending

[sunny_talwar]

See if this helps (Sorting on Y-value Ascending)

[markgraham123]

Sunny, i tried that but the X-axis values were loading from 1. So, it still shows the same result.

[markgraham123]

Hi,

Its still the same result.

[markgraham123]

Hi Ioannis,

Can you please explain it.

[sunny_talwar]

Isn't this what you want?