cancel
Showing results for 
Search instead for 
Did you mean: 

Line chart bug when inserting markers

I've recently noticed that there is this strange thing happening while using line charts.

 

So I need to compare A to B with two lines, I drop them to the chart area using just one axis (secondary is off) and I immediately notice the red line is way too high.

 

mariameowth_6-1632481697318.png

After switching on and off the secondary axis, the situation changes a little, but 49 is way too high for where it is:

 

mariameowth_7-1632481733396.png

 

I need to insert markers though…

mariameowth_8-1632481788380.png

the start of the axis had disappeared and the numbers don't look correct.

 

Even if I make the axis start with 0, 58.39 is still too high for my taste 🙂

mariameowth_9-1632481845451.png

If I transform it to the line and clustered  column chart, all works just fine:

mariameowth_10-1632481892650.png

 

Does anyone have any clue on how to resolve it?

 

Thanks!

Maria

Status: New
Comments
v-chuncz-msft
Community Support

@mariameowth 

 

Use Secondary Y axis along with Secondary values field. Otherwise, add data fields to Values only.