Convert from dotted to line graph in excel

In-efficient 61 Reputation points


How do I change the blue dotted graph to straight line graph? I have searched online but I could not find anything that is helpful. Below is an image the graph and the data.



User's image

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
905 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AllenXu-MSFT 10,421 Reputation points Microsoft Vendor

    Hi @In-efficient,

    As per my knowledge, I also think it is impossible to change the dotted graph to straight line graph in this scenario because of the loss of data in the cell B3, B5 and B7. The only workaround is to fill those blank cells.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments