URGENT: Creating a chart (Getting the correct input and output) unable to figure out

[desikerl]

Hi,

I have been trying to create this chart since a long time now and go
no clue what am donig wrong.

I have some machines in my company and all of them have a end of life
for example:

Machine 1, at location A with End of Life in 2004
Machine 2, at location B with End of Life in 2008

I want the years on x-axis and the machine locations on y-axis. Afte
that I want horizantal lines representing machines which also show th
end of life.

For a better understanding, see the attached excel file. I have als
created an image of the chart I'm looking to draw.

Please advise. Thanks.
Ker

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65134

 

[Debra Dalgleish]

You could create a bar chart from the data:

Move the 'End of Life' heading to cell D4
Select cells C427
Click the Chart Wizard button
Select the Bar chart type and the Clustered Bar sub-type
Click Next, and continue through the rest of the Chart Wizard.