Skip to Content
0
Former Member
May 26, 2008 at 12:34 PM

X-axis values on Custom charts

12 Views

Hi,

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.

Column A

8

6

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?

Thanks,

Amrita