x-axis Interval

M

-markc

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

X-Axis Appearing in Plot Area 2
Need to know the logic for determining the interval between Y axis labels 1
Excel 2003- Charts- date and time format on x-axis of XY chart 3
Trying to color every other X axis interval... 6
Plot a time series on the x-axis and categories on the y-axis 3
Chart adds in extra date values on the X axis 6
Defining X-axis scales as dates or times 3
Attach Data Table to Bottom of Plot Area 1

Top