Line graph and XY scatter graph are slightly off

[DashboardNovice]

In the attached file, I am working on the 2nd tab called "covered calls." The P&L line terminates at X = $55.00. This is also where the Max Gain line starts.

The strike price (blue line) also has X = $55.00. This is plotted as an XY scatter diagram.

Because the P&L, Max Gain and Strike Price all have X = $55.00 this means that the blue line should intersect the point where the P&L line terminates and the Max Gain line begins, but instead, the blue line is slightly to the left.

If you look at my source data, all 3 lines do have values of $55 so I'm not sure where the problem lies. On row 62 of columns T:U (yellow) I have $1,200 under T and under U. Could this have something to do with the problem?

 

[NARAYANK991]

Hi ,

Your secondary horizontal axis scaling should be identical to your primary horizontal axis scaling.

Narayan

 

[DashboardNovice]

Hi ,

Your secondary horizontal axis scaling should be identical to your primary horizontal axis scaling.

Narayan

I tried your suggestion and I'm still seeing the same thing.

 

[NARAYANK991]

Hi ,

Can you see this file and comment ?

If you think it is OK , you can remove the tick marks , labels for the secondary horizontal axis.

Narayan

 

[Jon Peltier MVP]

Plot all series as XY Scatter, with the black lines on the primary axis and colored lines on the secondary. The chart should have a secondary vertical axis, but only a primary horizontal axis, so all series use the same X axis. Line charts treat the X axis a bit differently (e.g., fractional values), but there is really no logical reason to plot your black lines as Line chart series.