monthly separation tick marks on x-axis

prince

You can use Jon's suggestion of a time series line chart or you can use an
XY trend chart with a custom X axis that will let you label your X axis
dates exactly the way you want.

Here's a link to a tutorial on making custom XY axis.

http://processtrends.com/pg_charts_custom_axis.htm

I have several examples of XY trend charts with custom axis , look he

http://processtrends.com/TOC_trend_charts.htm

Kelly

http://processtrends.com

"prince_mavs" wrote in message
...


"Jon Peltier" wrote:

This is where a Line chart is nicer than an XY chart. Create a line chart
with your data, then double click the X axis, click on the Scale tab,
choose
Days as your Base Unit, 1 Month as your Major Unit, and the first of any
relevant month as the Minimum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rab" wrote in message
...
I'm plotting a number of data series on an x-y scatter chart. Values
are
recorded daily over an 18 month period and are plotted against time on
the
x-axis. To make the graph look neat I want to place tick marks at
monthly
intervals at the first of each month. Because the number of days in
the
month varies it is not possible to select an appropriate major unit in
the
format axis box. As a result, if I select for example 31 as the major
unit
then the monthly tick marks progressively move to a later date in the
month -
starting from 01 August 05 and by March 07 my tick mark is placed at
the
13th. Is there anyway to overcome this? Thanks.