Blank/NA values to be shown as dotted line rather than straight line in Charts

Hello there,

I request your help on solving this question.

Say, I have values such as 1,2,3,4,5,6,7,8,9,10 plotted in Excel Chart.

If I want to delete values 3,4, the missing values can be interpolated using the "Hidden and Empty Cells" option. This option connects only through a thick line.

Can I change the interpolated values alone to show up as dotted line ?

Please let me know if this can be done.

Thanks.

Hi,

Yes, you can do it manually by selecting only the interpolated line -> change the line setting to a dotted line. See the attached file.