If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
x-axis Interval
Hi all,
Using Excel 2007 SP2 I am trying plot mmm char(13) yy on the x axis I currently have every 4th interval plotted Problem is, I have an odd accounting calendar that had a 6 week start So I would like to plot the first date, the 6th date and every 4th date after that Is this possible? Thanks g |
#2
|
|||
|
|||
x-axis Interval
You can't do that with the default axis labels. But you could add a
series with a point at each date along the axis (X = date, Y = axis minimum). Hide the series (no lines or markers) but add category data labels, and position them below the points. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ -markc wrote: Hi all, Using Excel 2007 SP2 I am trying plot mmm char(13) yy on the x axis I currently have every 4th interval plotted Problem is, I have an odd accounting calendar that had a 6 week start So I would like to plot the first date, the 6th date and every 4th date after that Is this possible? Thanks g |
Thread Tools | |
Display Modes | |
|
|