How to handle various date increments within X-axis of a scatter plot?

[cjweitz]

Hello,

I'm doing all of the following in a macro but I think the question is more generalized to "Chart" features than VBA. I'm graphing capacity values over time on a scatter plot ("widgets" on the y-axis and time on the x-axis). The counts are performed on Thursdays, i.e. weekly. I'm graphing longer time spans and want the major unit to be a "month." I just one each month once to be shown across the axis. I'm also overlaying with regression models and I don't think I can use a line graph with the GLM I'm using.

I can set the

Please Login or Register  to view this content.

and it shows Month and year correctly. Unfortunately the major and minor units are in Excel the 1904 datetime numbers (December 1, 2012 = 42144.0). This means months are shown like "Nov-12", "Dec-12", "Dec-12", "Jan-13","Mar-13","Mar-13", etc... and it looks kinda stupid. Any help would be great and thanks in advance.

Best,

Jeff

[Andy Pope]

scatter charts do not do time series axes like the Line/column charts do.
If you can not make use of Line chart and Time series axis then you will need to construct the required axis labelling on an xyscatter.

See these examples.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html