Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Plotting moving average line on a chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |