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 |
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 |
All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com