I have a Custom chart with the Pen Type as Line.
If I plot a numerical values as the X-axis, the X-axis ranges do not come as expected.
e.g. If my data comes as shown below and I am plotting column A on the X-axis, then the
X-axis labels would read as 6,8,5,4,3.
When I plot a Line Chart with the same data, the X-axis labels come properly in order(3,4,5,6,8).
If I do an explicit sort on the X-axis column, then the Custom Chart gets plotted correctly, but the requirement is such that I cannot do an explicit sort on the dataset.
Can anybody help me out on this?