Time line chart

[Confused]

I’m 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

 

[Barb R.]

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.

 

[Tushar Mehta]

Create a histogram.

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

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

--
Regards,

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