Getting a category x-axis to sort of "right-justify"

[sally]

I am using a category x-axis and want to create the following effect:

The tick marks and labels should be spaced out such that the last tic
mark is at the right-most x value. That sounds obvious enough a
first, but the number of categories is variable and the user does no
want to see every category marked. He wants to see, for example,
tick mark every 10 values.

The first category label appears in the leftmost corner of the char
but then marking every 10 values going across to the right wil
sometimes wind up with the rightmost tick somewhat to the left of th
last value on the right.

I have been handling this programmatically and adjusting the number o
categories between ticks to space it the way he wants, but I wa
wondering if anyone had any other ideas by setting the chart options.

Thanks for any help

 

[Andy Pope]

Hi,

Maybe you could adapt the technique described here.
http://www.andypope.info/charts/hiliteaxislabels.htm

The could handle the labels. As for the actual tick marks you could use
another series using cross data marker to mimic the tick mark. You will
need to plot this on the secondary axis, use the secondary xaxis and
un-set the value crosses between categories.

Cheers
Andy