Convert from dotted to line graph in excel

Question

Hello,

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.

Thanks,

IN

Answer 1

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.

Answer 2

Check the method described for Excel 2007:

• https://support.microsoft.com/en-us/topic/a-line-chart-may-plot-gaps-in-lines-when-the-data-range-contains-blank-cells-in-excel-83627518-5b2e-9082-b18c-e43c1c6370e7