software

I have a data set with dates in column A and values in column B. I
have this plotted as an X-Y graph. I can change the major units on the
X (date) axis, but only by integers. I would like for it to display
months, rather than equally spaced dates. The closest I can do, is to
use 30 days for the major unit on the X-axis. Is it possible to have
each month displayed rather than specific date in 30 day increments?

BillHi,

Try the following approach; I think that it would work.

If the lowest date in your data is not on the first of a month, create a
dummy date which is the first of the lowet month with no y-value for it, and
include that dummy point in the graph. Then

Right-click on quot;X-axisquot; --gt; quot;Format Axisquot;

--gt;quot;Scalequot; Tab:
Base Unit: select quot;Day(s)quot;
Major Unit: enter quot;1quot; and select quot;Month(s)quot;
Minor Unit: enter quot;1quot; and select quot;Month(s)quot;

--gt;quot;Numberquot; Tab:
Category: quot;Customquot;
Type: quot;mmm yyquot; (or quot;mmm yyyyquot;, or any other format you want)

Regards,
B. R. Ramachandranquot;Sam Fertelquot; wrote:

gt; I have a data set with dates in column A and values in column B. I
gt; have this plotted as an X-Y graph. I can change the major units on the
gt; X (date) axis, but only by integers. I would like for it to display
gt; months, rather than equally spaced dates. The closest I can do, is to
gt; use 30 days for the major unit on the X-axis. Is it possible to have
gt; each month displayed rather than specific date in 30 day increments?
gt;
gt; Bill
gt;
gt;