Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart shows 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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart shows all month-ends as 30th
How about changing the Base Unit to months on the Scale tab of Format Axis
Then you get the first of each month. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Alan Z. Scharf" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart shows all month-ends as 30th
Alan:
I assume neither of the datum formats give you what you want, so I didnt bother testing them all. I tried a work around as follows: Assuming yr datums are in A1 downwards, add three columns behind your data. (B,C,D) In B1 type the formula =Text(A1,"mm") [This returns a two number digit for the "month" specified in A1]. In C1 =Text(A1,"dd"). [This returns a two number digit for the "day" specified in A1]. In D1 =concatenate(B1,"-",C1). [This returns the format "mm-dd". Now go to yr chart, right click and select Source Data... Under the series tab define the range in D1 downwards as category X axis. It should show 09-30, 10-31, etc in your chart now (you can change the "-" of course by any separator you want, or add the year if needed in a similar way as described). In my Excel 2003 it returns the format you seek, so I hope it works for you. GL, Henk "Alan Z. Scharf" wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart shows all month-ends as 30th
Bernard & HEK,
The answer is to go to Chart Options on the menu, check Primary Axis (X), radio button Category, uncheck Secondary Axis(Y). Thanks for your replies. Alan "Alan Z. Scharf" wrote in message ... 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 | |||
How do I print comments on a chart? | Charts and Charting in Excel | |||
Line Chart | Charts and Charting in Excel | |||
Line Chart - 2 | Charts and Charting in Excel | |||
A Buggy Chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |