Plot Line Connecting to Axis

[johnfb73]

Hey there,

I've had a particular issue with Excel plots for a while that I have not been able to resolve.

When the data terminates (no values), instead of the line ending, it connects to the x or y axis (as shown below). I have tried using "#N/A" as well as blank cells for the dates with no values, but Excel still forces the line to connect to the closest axis.

Has anyone ever run into this issue and have a solution for it? I would love any feedback or help that can be provided! Thanks!

excel_issue.jpg

[Andy Pope]

You need to post an example file as we can not tell what chart type you are using or what the data used is.