Share via

Excel line chart won't skip missing data point, connect directly to the next data point. It return to zero.

Anonymous
2024-09-03T13:28:13+00:00

I have tried "Select Data" "Connect line..." It didn't work

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2024-09-04T12:28:23+00:00

    If you change the formulas in the work file to return NA() rather than "" then the line chart will treat them as empty. You can use conditional formatting if necessary to hide the #N/A errors in the cells.

    1 person found this answer helpful.
    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-03T17:43:48+00:00

    Could you share a test file to reproduce your issue?

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    0 comments
  2. Anonymous
    2024-09-03T20:39:22+00:00
    DS1 DS2 DS3 DS4 DS5
    Obs1 0.3 3.1 0.3 6.2
    Obs2 0.5
    Obs3
    Obs4 0.1 4.2 3.3 0.4 5.3
    Obs5 0.3 5.3 0.1
    Obs6 0.1 3.7 2.8 0.5 4.6
    Obs7

    When I used above test data, it didn't skip the missing points. The line return to x-axis.

    0 comments
  3. Anonymous
    2024-09-03T20:42:55+00:00

    it displayed like this

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more