Hi,
This is an x-axis time-scale question I've been unable to figure out for some time. Is there anyway to change individual dates that show on the axis while keeping the overall date interval intact? For example the x-axis labels would be: 1/10, 1/15, 1/20, 1/22, 1/25, 1/30...
Any help here would be GREATLY appreciated.
If you 'fiddle' with the major units and minor units of the axis scale you should be able to change the labels.
If you still have problems try changing the font size or text alignment.
If you still have problems post back with more specifics.
Hi brivera, and Welcome to the board,
You could rename the X-Axis labels using Rob Bovey's Most Excellent and Highly Desirable "X-Y Chart Labeler". Download it free from here:
http://www.appspro.com/utilities/Labeler.asp
This will let you pick a data series and name the Axis points anything you like, from a list you supply. For example, you could have a chart with those dates on the X-Axis and a list of whose birthdays they are, and use the birthday list to show "Mom", "Dad", "Sis", "Auntie Bill", etc..
HTH
Chris
Hi brivera,
Attached is an example of irregular time line axis labels.
It is created by using an additional data series.
You may also want to take a look at a previous thread on timeseries flags.
Cheers
Andy
Don’t have an account yet? Register yourself now and be a part of our community!
