Bar chart or bar graph for construction progress physical progress

[pvsvprasadcivil]

Dear all my well wishers,
I have a data of "From" "To" of Lengths, and Date.so how to draw bar graph in excel???please help me ...please find here iam attached sample input& output BAR GRAPH.please make guidance..

[pvsvprasadcivil]

Dear master,
i already tried many types of bar chart..but not getting as required bar chart presentation.

[Andy Pope]

You need to create a gantt chart.

Start by using formula to get the dates in order. Use MATCH to get lookup positions.
The use INDEX formula to create chart data.

The chart is a simple stacked bar.
The first series is set to no fill to create the floating bar effect.

[arvind sharma]

You need to create a gantt chart.

Start by using formula to get the dates in order. Use MATCH to get lookup positions.
The use INDEX formula to create chart data.

The chart is a simple stacked bar.
The first series is set to no fill to create the floating bar effect.

Good solution. I'm benefited. Thanks Andy. Repz added.

[pvsvprasadcivil]

You need to create a gantt chart.

Start by using formula to get the dates in order. Use MATCH to get lookup positions.
The use INDEX formula to create chart data.

The chart is a simple stacked bar.
The first series is set to no fill to create the floating bar effect.

Dear sir thank you for your reply...in your bar chart same series is repeated, i want if any series named as previous series..then bar should be placed at same series..example "Embankment top" named is repeated 2 times..and at y axis "Embankment top" more than 1 time.. so my concept is series names should be onetime for repeated LABELS or names...please find one more modified required graph output..

[Andy Pope]

You need to adjust the formula that builds the vertical axis labels.

If it is not a combination of the contents of columns D and E then add an extra column with required text and lookup that value.

[pvsvprasadcivil]

Dear sir,
i don't know how to adjust the Label..please suggest steps included.

[Andy Pope]

I added a column for bar labels.
Either type the reqquired text or use a formula to build the required text.

[pvsvprasadcivil]

I added a column for bar labels.
Either type the required text or use a formula to build the required text.

Dear sir,

In your sent excel file labels are repeated...but i need no repeat the same named label (Example--"Sub grade" is 2 times, "Embankment top" is two times..etc..)several single named label contains multiple bars is same series.please refer my example output.so please help me for my problem.

[Andy Pope]

your example does not clarify your problem.

What are the rules for the names to use? Post an example where you have manually entered the correct names and explain why.

[pvsvprasadcivil]

your example does not clarify your problem.

What are the rules for the names to use? Post an example where you have manually entered the correct names and explain why.

yes..sure sir here iam attached my requirement out put file with reference to input excel file.please try at least like this.

[Andy Pope]

You will need vba to build multiple stacks.

Maybe somebody else can help you out with that,

[pvsvprasadcivil]

Dear masters...please solve this problem..advance thanks to all