Chart Displaying Data with Unwanted Offset

Question

Level 1

35 points

Chart Displaying Data with Unwanted Offset

I'm not sure why there is a 50 point offset from 12900 to 12950 on the X Axis when "LC @Now Profit" and "LC @Expiry Profit" (columns I and J) are added to the Long Call chart.

There is nothing I can think of in the inputs in the formula that should cause this.

The lower blue straight line on the chart changes angle up at 12950 but it should do this at 12900 like the blue line above it? Any ideas?

Cheers!

Had to add image 3. Not sure why image 2 doesn't appear in full?

MacBook Pro 15″, macOS 12.3

Posted on Aug 18, 2023 7:42 AM

Reply

Answer 1

Best reply

Recycleur

Level 4

1,561 points

Aug 18, 2023 1:16 PM in response to Bardonicloud

The obvious is that your X and Y values don't align. Click a line in the chart, then in the toolbar Format / Series examine the references. X and Y should start on the same data row for all lines.

Reply

Answer 2

Bardonicloud Author

Level 1

35 points

Aug 19, 2023 5:56 AM in response to Recycleur

Thanks, the references were too high by 2 rows and needed dragging down.

Reply

Chart Displaying Data with Unwanted Offset

Similar questions