How to show vertical drop in the Y axis (Line graph).?

[Adarsh S]

Please find the attached file. In the below line graph the line is showing a slope. But I need a vertical drop. How to achieve this.

 

[GraH - Guido]

Switch to X/Y scatter chart with straight lines instead of a line chart. And adapt data series accordingly.
See attached.

 

[Adarsh S]

Thank you so much. . You saved my valuable time.

 

[Adarsh S]

Using the above method I was able to plot the required graph. But initially I used Line graph (Fig 2 sheet in the attached excel) and added some information that makes the graph more informative. But when I use scatter graph the information like Pipe diameter along chainage, exact chain age at all nodes are not being able to update. My query is can we update the details shown in HGL - Fig 2 to Fig 1 with all the relevant information? Please suggest.

 

[GraH - Guido]

I assume you talk about the data labels. In my version of Excel I can simply add them like for a line chart. There is a free add-on available for earlier version of Excel to allow easy labelling of scatter charts. Try to google that. I don't remember where I ever found that.

Your chart will get clutter however with all those labels.

 

[Adarsh S]

Thank you very much for your valuable input.

 

[vletm]

Adarsh S
Why do You want those 'labels'?
You have Your data left side and
if You would like to see any points values then move You mouse over that line and You will see...

 

[Adarsh S]

Thank you for the query. If you open the excel sheet there are two graphs (Fig 1 and Fig 2). In Fig 2 the HGL (red colour line slope is almost flatter). We need to submit a hard copy to the client. Hence, we need to show the Data labels.

 

[Adarsh S]

In the excel sheet, Graphs are shown in Fig 1 and Fig 2. Fig 2 is a Line graph and Fig 1 is Scatter graph.
My query is, Is it possible to show the x-axis length and diameter details shown in Fig. 2 to be shown in Fig 1? I tried the select data option, chart types etc. But was unsuccessful.
The length in the line graphs Fig 2 x-axis, shows the cumulative length in the graph. This provides proper space between consecutive numbers. But in Scatter graph (Fig 1), it doesn't show the exact cumulative length. But it shows with equal intervals. I would like to show the Scatter graph as Fig 2.

 

[vletm]

Adarsh S
... to submit a hard copy ... send a chart AND data-table too.
... #9 reply ... make a hand draw or show someway - what do You really NEED?

 

[Adarsh S]

Thank you very much. I want the graph look like the below. The graph should have all the details shown in Fig 2 of excel sheet. But the drop should be vertical.

 

[vletm]

Adarsh S
... But the drop should be vertical...
But Your data don't have that kind of values to get it vertical.

It would be possible to do by few tricks manually
You could split that orange line to three parts; before - just - after ...
something like this SAMPLE

 

[Adarsh S]

Thank you so much. I tried by splitting it into two columns but I didn't get that. This is a wonderful trick. Thanks.

 

[vletm]

Adarsh S
... with this, it would be more clear to 'move' vertical part left-right as needed.

 

[Adarsh S]

Yes it moves vertical and horizontal. You have used the Error bars. Thats a wonderful trick. Thank you so much for your creative ideas.