Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
MSGraph Showing All Month-Ends as 30th.
Hi,
1. I have an area chart covering six months of data 09/30/05 10/31/05 11/30/05 12/31/05 01/31/06 02/28/06 03/31/06 2. However, the X-axis shows 9/30/05 10/30/05 11/30/05 12/30/05 1/31/05 2/28/06 3/30/06. The only month endit gets right is 2/28. 3. Can anyone help with settings that would get 31st in relevant months? 4. Current X-Axis scale settings are below, all non-auto: Min 9/30/2005 Max 3/31/2006 Base Unit Days Major Unit 1 Month Minor Unit 1 Month Y Crosses 9/30/2005 Thanks. Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically determining when a month ends | New Users to Excel | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
blank cells showing up as a month 1 | Excel Worksheet Functions |