LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default End of Month tic marks in Excel 2007

I am charting a time series with dates starting with 31.12.2007 ending at
31.12.2008 and market values in the second column. In format axis I choose 1
months as the Major unit. In Excel 2003, this would give me a tick mark at
the end of each month for each month in 2008.

In Excel2007 however it will give me a tick mark at 31.01.2008 and then the
02.02.2008, 02.03.2008 ... 02.11.2008 ie. the 2nd of each month thereafter.
Has anybody find a solution to this? It is quite annoying so any help is much
appreciated.
 
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
excel to make the days cary over month to month automaticly GARY New Users to Excel 1 April 19th 08 06:05 PM
to get the relative marks from a table of names,subjects & marks? kswarrier Excel Worksheet Functions 2 February 19th 08 08:13 AM
Excel 2003 month to month data change grid Chad[_2_] Excel Discussion (Misc queries) 2 February 15th 08 01:36 AM
How to keep quote marks for CSV in excel Matt Excel Discussion (Misc queries) 0 August 1st 06 12:30 AM
Excel Quotation Marks! MaxFrance Excel Discussion (Misc queries) 6 March 29th 05 10:45 AM


All times are GMT +1. The time now is 12:37 PM.

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"