I am curious how this helper column chart differs from a chart with the=20
x-axis set to a 'category scale' (as opposed to 'time scale').

--=20
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
=3D Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,=20
says...
Shuvro,
=20
Generally, per Excel=E2=A4=3D3Fs help you can=E2=A4=3D3Ft create time-sca=
le charts from data=20
that is measured in intervals of hours, minutes, or seconds. Only days,=
=20
months, and years are considered base units in time-scale charts.
=20
To get around this limitation, assume you have the following time data in=
=20
cells A1:A11 and plotted data in cells B1:B11:
=20
Col A is Time Format Data
05/03/2005 23:00=09 6
05/03/2005 23:15=09 4
05/03/2005 23:30=09 5
05/03/2005 23:45=09 7
05/04/2005 0:00=09 6
05/04/2005 0:15=09 5
05/04/2005 0:30=09 3
05/04/2005 0:45=09 4
05/04/2005 1:00=09 5
05/04/2005 1:15=09 7
=20
Insert a helper column between columns A and B. Add the following text=
=20
conversion formula to cell B1 (the new helper column):
=20
=3DTEXT(A1,"mm dd yy hh:mm")
=20
Copy that formula down the range B1:B11. Finally create your chart using=
=20
the range B1:C11.
=20
Col A is Time Format Col B is Text Data
05/03/2005 23:00=09 05 03 05 23:00=09 6
05/03/2005 23:15=09 05/03/05 23:15=09 4
05/03/2005 23:30=09 05/03/05 23:30=09 5
05/03/2005 23:45=09 05/03/05 23:45=09 7
05/04/2005 0:00=09 05/04/05 00:00=09 6
05/04/2005 0:15=09 05/04/05 00:15=09 5
05/04/2005 0:30=09 05/04/05 00:30=09 3
05/04/2005 0:45=09 05/04/05 00:45=09 4
05/04/2005 1:00=09 05/04/05 01:00=09 5
05/04/2005 1:15=09 05/04/05 01:15=09 7
=20
The 15 minute difference can be calculated a 1 / 24 / 4, or 0.010417=20
=20
----------------------------
Regards,
John Mansfield
http://www.pdbook.com
=20
=20
"Shuvro Basu" wrote: