Next 3 months line of a chart shown in a different format/style

[slamanager]

Hi,

I have a chart showing 13 months data values per month, 1= met 2 = stable 3 = Miss.

So the chart shows 8 months of previous data then the current months value and the next three months all show met but these are forecasted months.

My question is I can get the data all ok and do the forecast values but those forecasted values need to be shown on the chart past the current month in a dotted line style not in a solid line style.
Q. How do I get those last three months shown in a dotted style without VBA.
B1:N1 months label
B2:N2 data value 1,2,3

 

[thisoldman]

To show a line using a different color or using a different line-style requires a new series.

Try plotting this as a line chart:
[TABLE="class: grid"]
<tbody>[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: center"]A[/TD]
[TD="class: xl63, align: center"]B[/TD]
[TD="class: xl63, width: 64, align: center"]C[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]Actual[/TD]
[TD="class: xl63"]Forecast[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl64, align: right"]Aug[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl64, align: right"]Sep[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl64, align: right"]Oct[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl64, align: right"]Nov[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl64, align: right"]Dec[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl64, align: right"]Jan[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]

There's one point, for October, where the forecast overlaps the actual. Without that overlap, there would be a gap—the two lines wouldn't join.