Time line chart
 

Im trying to make a time line chart for a series of dates. Some dates are
duplicated, which I want to be represented on the €œY€� axes as a whole number
(1, 2, 3, etc). The end result should display if there is any trends for
returned parts. "X" axes starts on 05/01/04 and end on 06/01/05. If I have
4 dates of 8/23/04 the it should plot on the "X" axes between 8/01/04 and
8/30/04 and on the"Y" axes at 4. This sound like it should be easy, but I've
tried everything.

Help,
Confused

Is this what you are looking for?

http://www.peltiertech.com/Excel/Charts/GanttChart.html

Jon Peltier has a host of examples on his site.

"Confused" wrote:

Im trying to make a time line chart for a series of dates. Some dates are
duplicated, which I want to be represented on the €œY€� axes as a whole number
(1, 2, 3, etc). The end result should display if there is any trends for
returned parts. "X" axes starts on 05/01/04 and end on 06/01/05. If I have
4 dates of 8/23/04 the it should plot on the "X" axes between 8/01/04 and
8/30/04 and on the"Y" axes at 4. This sound like it should be easy, but I've
tried everything.

Help,
Confused

Create a histogram.

Enter the end-of-each-month in some column. Then, create a histogram=20
(Tools | Data Analysis... | Histogram). Specify the end-of-month range=20
as the bin range.

Alternatively, use a PivotTable. Add a column to your data. Call it=20
YYMM. Each cell in this column should have the formula =3DYEAR(A2)*100
+MONTH(A2), where in my case A2 contained the actual date. Now, create=20
a PT (Data | PivotTable and PivotChart... -- keep in mind this menu=20
item name has changed over the last few versions of XL). Specify the=20
YYMM column as a row field and as the data field. XL should create a=20
Sum of YYMM data item. Double-click the header and in the resulting=20
dialog box pick Count instead of the (default) Sum.

--=20
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,=20
says...
I=E2=A4=3D3Fm trying to make a time line chart for a series of dates. So=
me dates are=20
duplicated, which I want to be represented on the =E2=A4=BDY=E2=A4=9D axe=
s as a whole number=20
(1, 2, 3, etc). The end result should display if there is any trends for=
=20
returned parts. "X" axes starts on 05/01/04 and end on 06/01/05. If I h=
ave=20
4 dates of 8/23/04 the it should plot on the "X" axes between 8/01/04 and=
=20
8/30/04 and on the"Y" axes at 4. This sound like it should be easy, but =
I've=20
tried everything. =20
=20
Help,
Confused
=20