Plotting points on X-axis on SPC Chart

[Former Member]

Hi All,

I am using an XBAR chart to plot col1(Date Type on X-axis) v/s col2(Number on Y-axis).

It might be as follows:

x-axis(col1) y-axis(col2)

12-NOV-07 520

13-NOV-07 450

15-NOV-07 250

16-NOV-07 521

17-NOV-07 451

18-NOV-07 412

19-NOV-07 123

From above you can observe that on 14-NOV-07 there is no data existing. But when I plot the data, on x-axis label it needs to show equal intervals of one day lag(12-NOV-07,13-NOV-07,14-NOV-07,15-NOV-07 etc.,) but it is showing intervals as 12-NOV-07,13-NOV-07,15-NOV-07,16-NOV-07 etc.,missing out the interval on 14-NOV-07. I had tried using timestamp column option for setting the datetype column. but it is of no use. Does xMII provide this feature?

Any suggestions on this regard is highly appreciated.

Thanks,

Ravi kumar.

[jcgood25 · Accepted solution]

The iSPCChart will not just make up this label for you, as it only plots values for the XAxis Labels based upon actual data records, so since you do not have a record for the 14th you will not see this label.

Only the iChart in Line mode with a time based query will create equally distributed timestamp labels for you.

Regards,

Jeremy

[Former Member · Accepted solution]

Hi Jeremy,

Thanks for that information. I tried inserting a record with some value on missing dates and I tried suppressing the point. but when I suppress the point even the range is getting downsized.

Is there a workaround to show that x-axis label on that days having no data by manipulating input data for chart and still not showing that point on the screen?

Thanks & Regards,

Ravi kumar.

[jcgood25 · Accepted solution]

Then don't use an SPC Chart - it's not intended to do this.

[Former Member]

SPC Charts generally do not have an "interpolated" X-axis. By definition, the values correspond to "sample groups", which need not be evenly spaced.