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

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

pmroz — Wed, 19 Oct 2016 02:08:58 GMT

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

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

ron_horne — Fri, 28 Oct 2016 13:24:54 GMT

hi PMroz,

are any of the comments on this link of use?

uneven intervals on the axis

Ron

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

pmroz — Wed, 16 Mar 2016 14:52:30 GMT

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.

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

KarenC — Wed, 19 Oct 2016 02:09:08 GMT

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

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

pmroz — Thu, 17 Mar 2016 12:06:17 GMT

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