Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates
I am charting by dates, but am not consistent on gathering info. I have info
from 9/31/2002, 12/31/04 2/4/5, 4/1/5, 4/18/5 and from then on info every two weeks or so. But I need them to show up with the correct time intervals in between. It should be a long way from 9/31/2002 to 12/31/04 and shorter times from 9/1/6 to 9/15/6 to 10/1/6. Is there away to have the chart picture the actual time line with correct distances in between? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates
Hi,
If those values where actual dates then the chart should attempt to plot them as a Time series , which would give you the proportional gaps between points. But I suspect the are not all true dates and as such are being treated as text for an categorical axis. This looks doggy, 9/31/2002 , as September only has 30 days. Cheers Andy tbyrd007 wrote: I am charting by dates, but am not consistent on gathering info. I have info from 9/31/2002, 12/31/04 2/4/5, 4/1/5, 4/18/5 and from then on info every two weeks or so. But I need them to show up with the correct time intervals in between. It should be a long way from 9/31/2002 to 12/31/04 and shorter times from 9/1/6 to 9/15/6 to 10/1/6. Is there away to have the chart picture the actual time line with correct distances in between? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates
Yes. Make sure you use XY graph.
-- David Biddulph "tbyrd007" wrote in message ... I am charting by dates, but am not consistent on gathering info. I have info from 9/31/2002, 12/31/04 2/4/5, 4/1/5, 4/18/5 and from then on info every two weeks or so. But I need them to show up with the correct time intervals in between. It should be a long way from 9/31/2002 to 12/31/04 and shorter times from 9/1/6 to 9/15/6 to 10/1/6. Is there away to have the chart picture the actual time line with correct distances in between? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates
Geez Louise. All that frustration and you picked it right out. I had a bad
date right at the start. Works perfectly. Thanks, Tom "Andy Pope" wrote: Hi, If those values where actual dates then the chart should attempt to plot them as a Time series , which would give you the proportional gaps between points. But I suspect the are not all true dates and as such are being treated as text for an categorical axis. This looks doggy, 9/31/2002 , as September only has 30 days. Cheers Andy tbyrd007 wrote: I am charting by dates, but am not consistent on gathering info. I have info from 9/31/2002, 12/31/04 2/4/5, 4/1/5, 4/18/5 and from then on info every two weeks or so. But I need them to show up with the correct time intervals in between. It should be a long way from 9/31/2002 to 12/31/04 and shorter times from 9/1/6 to 9/15/6 to 10/1/6. Is there away to have the chart picture the actual time line with correct distances in between? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Dates showing are not what I type | New Users to Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |