|
Posted to microsoft.public.excel.charting
|
|
|
monthly separation tick marks on x-axis
"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.
|