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 Time-value axis labels

I am using a time-value x-axis. My minimum point is 10/31/08 and my maximum
is 10/31/11. I have the base unit as days and the major unit interval set as
months. In Excel 2003, this gave me axis labels of 10/31, 11/30, 12/31 etc.
In 2007 it gives me 10/31, 12/1, 1/1 etc. - I cannot figure out how to make
it show the labels as of the last day of the month instead of the first day
of the next month.
 
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
Overlapping time (X) axis labels with auto axis options Paul Kraemer Charts and Charting in Excel 1 February 8th 09 03:44 AM
Excel 2007 text labels in category axis - missing labels Boris Charts and Charting in Excel 3 December 5th 08 04:33 PM
Data labels along below x axis when y axis has negative values Andrew Charts and Charting in Excel 1 July 3rd 08 08:36 PM
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) Holger Gerths Charts and Charting in Excel 8 June 5th 08 04:25 PM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM


All times are GMT +1. The time now is 05:24 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"