LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rab Rab is offline
external usenet poster
 
Posts: 12
Default monthly separation tick marks on x-axis

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Placement of tick marks J. McAdams Charts and Charting in Excel 4 May 21st 23 07:44 PM
x axis tick marks Buckeye5 Charts and Charting in Excel 3 February 8th 07 11:27 PM
Tick marks ofey New Users to Excel 5 November 21st 05 06:32 PM
Y-axis tick marks in middle of chart? Ed Charts and Charting in Excel 6 May 26th 05 01:16 PM
Need specific tick marks on Y axis myhounds Charts and Charting in Excel 1 March 26th 05 06:59 AM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"