Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look-up a value within an interval | Excel Worksheet Functions | |||
Excel 2007 - change interval between labels on X axis | Charts and Charting in Excel | |||
x-axis time interval | Charts and Charting in Excel | |||
Formula used by Excel to determine y-axis interval in chart | Excel Discussion (Misc queries) | |||
Need to know the logic for determining the interval between Y axis labels | Charts and Charting in Excel |