Line Chart Series Vertical Line

[HappyHole]

Hi All

I have a line chart that displays a comission scheme for a salesperson. The commission paid (Y axis) depends on the sales generated (X axis).

Let's assume
$100 = $0 payment
$200 = $0 payment
$300 = $50 payment
$400 = $100 payment

At $299 of sales, nothing is paid. The line should therefore travel along the X axis at zero for the first three points ($100 - $300) then at $300 be vertical to the $50 payment line on the Y axis, then at some angle thereafter.

When I chart this, it appears to show that commision kicks in at $201 of sales.

If anyone can help, I would really appreciate it.

Kind regards,

HappyHole

 

[pgc01]

Hi

Use a scatter chart instead.

Use for your example:

X,Y
100, 0
200, 0
300, 0
300, 50
400, 50
400, 100

Please try

 

[HappyHole]

Thanks PGC - that's exactly what I wanted.

Kind regards

HH

 

[BSMoffatt]

Hi there, this is quite old thread. I was too having the similar problem regarding line chart and this thread really helped me. Thank you.

 

[pgc01]

You're welcome. Thanks for the feedback.