This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
As displayed in following screenshot I have created a scatter line chart with the available data in the excel where I don't have data for 3rd row and we could see there are two lines created for a single series Department, one line with first two data points and another with remaining data points. But ideal should be a single line is what we are expecting. Could you please help us with this observation, is there any work around to fix this?
please refer the series X values and Series Y values displayed.
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.
We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.
Hi @Andreas,
I am not seeing an option to attach the sample file. Could you please help me on how I can attach the file?
Thanks,
Thilak
Hi Andreas,
If you see in the below image, in the first chart, the scatter wil line and marker got has been rendered as single line.
But in the second chart, since 24-Feb has a null value, the chart got split into and there is a disconnect in the line.
https://learn-attachment.microsoft.com/api/attachments/9d4c0322-c410-4002-a0c8-136e0b2ccfe8?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/9d4c0322-c410-4002-a0c8-136e0b2ccfe8?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">
So we would like to know if there is a way in Excel to avoid this disconnect of the line. Please help.
Date used is
| Period | Price |
|---|---|
| 23-Nov | $14.12 |
| 23-Dec | $13.88 |
| 24-Jan | $13.33 |
| 24-Feb | $13.21 |
| 24-Mar | $13.31 |
| 24-Apr | $12.98 |
| 24-May | $13.06 |
| 24-Jun | $13.24 |
| 24-Jul | $13.23 |
Sorry unable to attach the file here,
Pls let me know if you need any other info.
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
Hi @Andreas, I am not seeing an option to attach the sample file. Could you please help me on how I can attach the file?
Read the entire web page that Andreas provided a link to.
But I empathize: it is hard to see "the forest through the trees".
Why not simply explain....
We cannot attach files directly in this forum.
Instead, share a view-only link that allows us to download the file without having to log in.
Upload the file to a file-sharing website such as box.net/files, dropbox.com, onedrive.live.com, etc.
I deprecate the use of Google Drive because too many users misunderstand and import the Excel file into Google Sheets. That might alter formulas; and of course, we loose Excel-specific features such as application options, which might affect some problems. (Not this one.)