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

[palaniappan0212]

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.

 

[oldbrewer]

1
2
3	3
	4
	5
6	6
7
8
9
10
	if you add another data range
	as above it can be formatted as dotted line
	now 3 and 6 are joined by a dotted line

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>