Vertical Line on a graph

[pedexe90]

Hi everyone,

I would like to add a vertical line passing through the maximum point on of the graph and touching the x-axis.

How do I go about it by combining two charts. I have the x and y values.

https://1drv.ms/x/s!AgQdYsSdg735ez8qaqRpoC-34QY

thanks

 

[pgc01]

Hi

Add another series with just 2 points

(Sal,0)
(Sal,Max)

 

[pedexe90]

Hi

Add another series with just 2 points

(Sal,0)
(Sal,Max)

Thank you for your reply.

Yes I have tried that but it does not work. Maybe I'm doing something wrong but do I need to combine this scatter diagram with a bar diagram with those two points?

Would you be able to illustrate it on the uploaded file?

Many thanks

 

[pgc01]

Hi

No. Just add the new series that is also scatter.

In the ribbon Chart Tools->Design->Select Data add the new series with just those 2 points.

 

[pedexe90]

Thanks for the reply.

So I have added the two points but naturally as this is a scatter diagram, I only get two points on the graph rather than a line. How do I connect these two points? (https://1drv.ms/x/s!AgQdYsSdg735ez8qaqRpoC-34QY)


Thanks

 

[pgc01]

So I have added the two points but naturally as this is a scatter diagram, I only get two points on the graph rather than a line.

Hi.

No, there are 5 types of scatter charts:

Scatter with only Markers
Scatter with Straight Lines
Scatter with Straight Lines and Markers
Scatter with Smooth Lines
Scatter with Smooth Lines and Markers

You are using the first one and you should be using the second or the third (depending on whether you want to see the markers)

Right-click on one of the markers and choose

Change series chart type...

and select the type you want.