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

Timeline Plots 0
Make Y-axis values correspond to x- axis value 1
X-Axis Appearing in Plot Area 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Trying to color every other X axis interval... 6
Offset Horizontal axis data 1
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

Top