Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hey Mark
I think you forgot to attach. Please attach it again.
Best,
Sunny
Hi Sunny,
How are you?
Here is my attachment.
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
Create a line chart with Dimension: Product & Expression : Sum(Sales)
Now go to chart properties and go to sort Tab, check Y-value Ascending
See if this helps (Sorting on Y-value Ascending)
Sunny, i tried that but the X-axis values were loading from 1. So, it still shows the same result.
Hi,
Its still the same result.
Hi Ioannis,
Can you please explain it.
Isn't this what you want?