Pivot Tables to Gantt Charts

[chonk75]

Hello everyone,

My problem basically is i'm constructing a time line to show the different times at which a fault occurs in different locations. The data I am using is in the form of excel spreadsheets the difference between the data is the location in the country so therefore all the data can be compared. Ideally I would like to convert the time it takes a fault to arise to the time it is when it clears as some sort of graphical representation such as something like a gantt chart, but i need a much faster way of quantifying the results as i have several thousand. Please help!

 

[nbrcrunch]

I can't answer your specific question but I can point you to a site with exceptional coverage of charting:

http://peltiertech.com/Excel/Charts/index.html

 

[tactps]

A bit outside the square, but I've done similar things using the stock charts (which looks a bit like a gant chart on it's side).

Note - you will need 3 series minimum to use this. You can get around this by using a blank series.