Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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
Question marked as Top-ranking reply

Posted on Aug 18, 2023 1:16 PM

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.

2 replies

Chart Displaying Data with Unwanted Offset

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.