If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I set month/quarter/annual date intervals
I have data collected on a daily basis (for work days) over several years,
and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
#2
|
|||
|
|||
How can I set month/quarter/annual date intervals
It sounds like you are using an XY chart.
For XY trend charts, I often run into the issue you are talking about frequently. I use a few formatting tricks: For my X Axis number format I double click the X axis to get Format Axis window. I select number tab and enter my date format. For monthly data spanning years, I use "mmm'yy" which will show up as Mar'06 on the chart X axis. For my interval, I use 32 days to make sure that I get my months to increment. I have several trend chart examples at http://processtrends.com/pg_charts_trend_chart.htm ...Kelly "John" wrote in message ... I have data collected on a daily basis (for work days) over several years, and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
#3
|
|||
|
|||
How can I set month/quarter/annual date intervals
Thanks, Kelly, but this did not work for me. When I used 32 days, after about
every 20 months, it skipped a month on the axis, as if it were "rounding" to the nearest month. I have an old chart that has on the x-axis, 1/4/99, 2/4/99, 3/4/99, etc through 8/4/04. Unfortunately all I have is a printed copy and have lost the Excel file from which it was printed. So I know it can be done, but I just can't figure it out. "Kelly O'Day" wrote: It sounds like you are using an XY chart. For XY trend charts, I often run into the issue you are talking about frequently. I use a few formatting tricks: For my X Axis number format I double click the X axis to get Format Axis window. I select number tab and enter my date format. For monthly data spanning years, I use "mmm'yy" which will show up as Mar'06 on the chart X axis. For my interval, I use 32 days to make sure that I get my months to increment. I have several trend chart examples at http://processtrends.com/pg_charts_trend_chart.htm ...Kelly "John" wrote in message ... I have data collected on a daily basis (for work days) over several years, and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
#4
|
|||
|
|||
How can I set month/quarter/annual date intervals
John:
How many months of data do you have to chart? Have you tried 2 month interval (63 days)? What about quarter (94 days)? ...Kelly "John" wrote in message ... Thanks, Kelly, but this did not work for me. When I used 32 days, after about every 20 months, it skipped a month on the axis, as if it were "rounding" to the nearest month. I have an old chart that has on the x-axis, 1/4/99, 2/4/99, 3/4/99, etc through 8/4/04. Unfortunately all I have is a printed copy and have lost the Excel file from which it was printed. So I know it can be done, but I just can't figure it out. "Kelly O'Day" wrote: It sounds like you are using an XY chart. For XY trend charts, I often run into the issue you are talking about frequently. I use a few formatting tricks: For my X Axis number format I double click the X axis to get Format Axis window. I select number tab and enter my date format. For monthly data spanning years, I use "mmm'yy" which will show up as Mar'06 on the chart X axis. For my interval, I use 32 days to make sure that I get my months to increment. I have several trend chart examples at http://processtrends.com/pg_charts_trend_chart.htm ...Kelly "John" wrote in message ... I have data collected on a daily basis (for work days) over several years, and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
#5
|
|||
|
|||
How can I set month/quarter/annual date intervals
Kelly,
It varies. Sometimes I have 5 years worth, so that would be 60 months. Since months, quarters, and years are of different lengths, having a certain number of days as the major unit on the scale doesn't work out. Is there a way to tell Excel to have as the major unit on the scale months or quarters or years, even though the data are plotted by days? This is a format axis issue, and I have done it before, but don't remember how. John "Kelly O'Day" wrote: John: How many months of data do you have to chart? Have you tried 2 month interval (63 days)? What about quarter (94 days)? ...Kelly "John" wrote in message ... Thanks, Kelly, but this did not work for me. When I used 32 days, after about every 20 months, it skipped a month on the axis, as if it were "rounding" to the nearest month. I have an old chart that has on the x-axis, 1/4/99, 2/4/99, 3/4/99, etc through 8/4/04. Unfortunately all I have is a printed copy and have lost the Excel file from which it was printed. So I know it can be done, but I just can't figure it out. "Kelly O'Day" wrote: It sounds like you are using an XY chart. For XY trend charts, I often run into the issue you are talking about frequently. I use a few formatting tricks: For my X Axis number format I double click the X axis to get Format Axis window. I select number tab and enter my date format. For monthly data spanning years, I use "mmm'yy" which will show up as Mar'06 on the chart X axis. For my interval, I use 32 days to make sure that I get my months to increment. I have several trend chart examples at http://processtrends.com/pg_charts_trend_chart.htm ...Kelly "John" wrote in message ... I have data collected on a daily basis (for work days) over several years, and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
#6
|
|||
|
|||
How can I set month/quarter/annual date intervals
Kelly,
Success! Whoopee! I finally figured it out. Instead of an X-Y chart, use a Line chart. Then I can have the major units as months. John "Kelly O'Day" wrote: John: How many months of data do you have to chart? Have you tried 2 month interval (63 days)? What about quarter (94 days)? ...Kelly "John" wrote in message ... Thanks, Kelly, but this did not work for me. When I used 32 days, after about every 20 months, it skipped a month on the axis, as if it were "rounding" to the nearest month. I have an old chart that has on the x-axis, 1/4/99, 2/4/99, 3/4/99, etc through 8/4/04. Unfortunately all I have is a printed copy and have lost the Excel file from which it was printed. So I know it can be done, but I just can't figure it out. "Kelly O'Day" wrote: It sounds like you are using an XY chart. For XY trend charts, I often run into the issue you are talking about frequently. I use a few formatting tricks: For my X Axis number format I double click the X axis to get Format Axis window. I select number tab and enter my date format. For monthly data spanning years, I use "mmm'yy" which will show up as Mar'06 on the chart X axis. For my interval, I use 32 days to make sure that I get my months to increment. I have several trend chart examples at http://processtrends.com/pg_charts_trend_chart.htm ...Kelly "John" wrote in message ... I have data collected on a daily basis (for work days) over several years, and I want to plot it on an X-Y plot versus date. I would like the monthly intervals showing on the scale to be like 1/1/04, 2/1/04, 3/1/04, etc. Similarly, for annual intervals, 1/1/03, 1/1/04, 1/1/05, etc. Excel just wants to put in the same number of days for the intervals. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subforms to autopopulate from main form | Dale | Using Forms | 3 | March 7th, 2006 03:57 AM |
DATE PROBLEM | terryh70 | Using Forms | 4 | January 27th, 2006 01:02 PM |
Adding info to query | mjj4golf | Running & Setting Up Queries | 20 | January 9th, 2006 02:29 AM |
date intervals | M | Running & Setting Up Queries | 2 | October 27th, 2005 04:53 PM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |