Need Uneven Intervals on X Axis in Graph Builder (value labels didn't work)

[#1]

Hello all,

I've seen similar questions but nothing quite like this one.  I have data that looks like this:

Period	Start Date	End Date	RF
1	01Jan2005	31Dec2005	0.1
2	01Jan2006	30Jun2006	0.2
3	01Jul2006	31Dec2006	0.3
4	01Jan2007	31Dec2007	0.4

The Period column consists of consecutive integers, usually starting at 1.  As you can see the Start Date column has uneven increments.  Users want to see a graph of RF vs Period:

However the analysis we're doing is based on the Start Date column.  That graph looks like this:

I'd like to have something like the second graph, only with Period numbers on the X axis, unevenly spaced.  I tried setting value labels for Start Date but when dragged Start Date onto the X axis it ignored my value labels.

Thanks for any suggestions!

Peter

[#2]

hi PMroz​,

are any of the comments on this link of use?

uneven intervals on the axis

Ron

[#3]

I looked at that before posting and the best suggestion was from Xan: add labeled reflines for the "real" labels.  Was hoping for something easier.

[#4 · Accepted solution]

Peter,

I "tricked" graph builder into doing this:

I used reference lines with 0% color with labels and then changed the increment on the x-axis until is was such that no dates plotted.  So if you can script that maybe it would work. It would be a "pain" to do for a large dataset or more than once. It would be better if value labels would translate to the axis labels.

Ah but this is what you might have already found.....so I have nothing for you.

Good Luck

Karen

[#5]

Thanks Karen.  I was headed in that direction but your answer provided good clarification.