Excel Graph Help - Timelines/Plans

[sebhaque]

Hi there,

I'm trying to make a graph that documents the lives of some of the components we use at work. I can use this as a project to help streamline life analysis.

Essentially, I've got ~200 component IDs with a first inspection time, and a life limit. These lives range from 6,000-10,000 hours.

What I'd like to be able to do is have a graph where the timeline is running along the bottom (1000 hours, 2000 hours, 3000 hours etc), with a little bar appearing at the first inspection and life limit of the different components. Alternatively, is there any way (apart from doing it manually in Excel) to allocate each component a "slot" or row, with a point at its inspection time, and its life limit?

If it helps, use the following as a reference:

Part No - Inspection Time - Life Limit
Part 01 - 3000 hours - 6000 hours
Part 02 - 1000 hours - 6000 hours
Part 03 - 533 hours - 4000 hours
Part 04 - 2000 hours - 3000 hours
Part 05 - 4000 hours - 12000 hours

Thanks in advance.

 

[Steve=True]

Here is what you are looking for.

To do it with a bar chart would be difficult since your data is not uniform (i.e. 533 vs points only at thousands position)

This is done with an XY line chart.

http://www.4shared.com/document/o0HbNDXp/timelinedemo.html

 

[sebhaque]

That's perfect - thank you very much!