Hi, I'm going crazy with a 'simple' graph that I'm trying to make; better than million of words, a picture (attached).



Can someone tell me why the grey line (but not only it,also the other two have the same types of problems) is completely wrong? Notice that:
- left point value: 43 -> this one is the only one in the correct position
- middle point value: 8 -> wrong!between line 20 and 30
- right point value: 15 -> wrong!above line 50 and above the left point!

thank you!

mik

Attached Images

exc.png (60.7 KB, 20 views)

Hi and welcome
please post your sheet, an image cannot be worked with.
Thank you
( click "Go advanced - Manage attachments")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

file attached!

Attached Files

y - Copy.xlsx (17.8 KB, 11 views)

When I open your sheet the line graph has a secondary y-axis with a different scale.
Removing this one and reapplying the line graph worked.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

But how you do this? I try selecting each line and doing: right click -> Format Data Series ->Plot series on PRIMARY AXIS but the result is what you see in my first post...

Right click the Chart - Select Change chart type - Click Line in the left column then click on the line with markers icon - OK

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thank you!